Haven't yet seen a monster formula with that many nested functions!

--
Biff
Microsoft Excel MVP


"FSt1" wrote in message
...
Thanks. i knew it went up but was guessing on that one.

Regards
FSt1

"T. Valko" wrote:

in 2007, this has been increased to 16(i think).

64 nested levels in Excel 2007.


--
Biff
Microsoft Excel MVP


"FSt1" wrote in message
...
hi
could you give an example of what would be in C3?

As to number of nested ifs, in 2003, you are limited to 7. in 2007,
this
has
been increased to 16(i think).

Regards
FSt1

"bbal20" wrote:

I was wondering if there is a way to re-write the formula below or
nest
more
than 7 IF scenarios. I need to be able to check for several scenarios
or
more
than 7. Is this possible?

=IF(ISNUMBER(SEARCH("TIER 1",$C3,1)),"TIER 1",IF(ISNUMBER(SEARCH("TIER
2",$C3,1)),"TIER 2",IF(ISNUMBER(SEARCH("TIER 3",$C3,1)),"TIER
3",IF(ISNUMBER(SEARCH("Chicago",$C3,1)),"Chicago", IF(ISNUMBER(SEARCH("St.
Louis",$C3,1)),"St. Louis","Not Valid")))))
--
Thank you for your help and support