It's usually better to use other approaches when that amount of
possibilities exist.
You can perhaps describe your situation with some examples of what you have
and what you want to return, so that you can get some suggestions to
alternate solutions.
If you absolutely wish to use nested IF's, try this link:
http://www.cpearson.com/excel/nested.htm
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
Is there a way to exeeed the limit of 7 IF statemnets
within an expression. I need to write one with 10 IF
ststements
