need to exceed nesting limitations

S

stacy pohl

I need to exceed the 7 nesting function limitation. I am trying to d
this by creating seperate nesting functions and defining them by nam
and then create a master formula including each named formula, but I a
not certain how to accomplish this??:confused
 
M

Mark Graesser

Hi Stacy
Why do you need to exceed the nested limit? You can usually use one of the LOOKUP function, usually VLOOKUP, more efficiently

If you really need to get around the limit one way is to not nest the functions. Try something like

=IF(A1="A",1,0)+IF(A1="B",2,0)+IF(A1="C",3,0)+IF(A1="D",4,0)+..

If you are returning text, then use "" instead of zero for the false condition and change the +'s to &'s

Since the functions aren't nested there is no limit. You might need to use AND or OR functions in your criteria to acheive what you need

Good Luck
Mark Graesse
[email protected]
Boston M

----- stacy pohl > wrote: ----

I need to exceed the 7 nesting function limitation. I am trying to d
this by creating seperate nesting functions and defining them by nam
and then create a master formula including each named formula, but I a
not certain how to accomplish this??:confused
 
Top