I'm still in Excel 2003, I was just wondering. I've recently written a
formula with 6 nested if's, and now suddenly need a 7th - Ouch !!

Overall suggestions seem to be to convert to a Vlookup method, but not sure
at this point how to Set up my scenario table.

Thanks Roger !!


"Roger Govier" wrote:

Hi Jim

Yes you can.
I think the limit is now 256, but I don't think I would want to use the
limit!!!<bg

--
Regards
Roger Govier



"Jim May" wrote in message
...
Can you now enter more than 7 nested If's in this version?