need to exceed nesting limitations

[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

 

[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
(e-mail address removed)
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