if function

  • Thread starter Thread starter jc
  • Start date Start date
J

jc

I need to make an "if" function that contains 27
individual "ifs" - Excel doesn't seem to want to. After I
get past 10, it just keeps highlighting "if" in the same
spot in my formula and giving me an error message. Even
if I remove that particular entry, it does the same thing
until I get down to 10(I think it's ten) and then it works
fine. Any ideas?
 
I need to make an "if" function that contains 27
individual "ifs" - Excel doesn't seem to want to. After I
get past 10, it just keeps highlighting "if" in the same
spot in my formula and giving me an error message. Even
if I remove that particular entry, it does the same thing
until I get down to 10(I think it's ten) and then it works
fine. Any ideas?
Click to expand...

Excel has a maximum nesting limit of seven. You cannot nest more than seven
functions.

It is likely that a lookup table or some other approach will be more functional
for you. If you want further help, post the details of what you are trying to
accomplish.


--ron
 
It's an excel limit. You have to name the ranges of the
cell and refer to the name ranges in the if formula.
 
Back
Top