More than 8 cond. in IF-formula

  • Thread starter Thread starter Jonsson
  • Start date Start date
J

Jonsson

Hi ,

As I know it, excel doesnt manage more than 8 IF-statements.
Is it possible to do it some other way?

//Thoma
 
Hi

Various other ways are possible. If you post what you've got, with sample
data, and what you want, I'm sure someone will oblige! The most likely
solution will be a lookup table.
 
Hi
in most cases using VLOOKUP and a lookup table can be used. But this
depends on your conditions
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

filter and delete 3
Trying to test for multiple of 5, or .5, .05, .005, .0005 10
More than 3 Cond. Formats?? 4
Conditional Format? 4
Returning a value rather than TRUE or FALSE. 3
Conditonal formatting problem! 1
Percentage of Cells completed 3
summing across worksheets conditionally and being able to copy for 4

Back
Top