Alternate solutions often use a lookup function instead (eg Lookup, Vlookup,
Index/Match). Choose might also be worth taking a look at (see XL help for
description).
Other methods (defined names or user defined functions) are discussed he
http://www.cpearson.com/Excel/nested.htm
"Chris T-M" wrote:
Duh! Thank you very much.
Now if I can just simplify 21 nested IF statements into 7 I'll be set.
"Michael" wrote:
Try this:
=IF(OR(I54=2,I54=3,I54=4),"Low","")
--
If this posting was helpful, please click on the Yes button.
Regards,
Michael Arch.
"Chris T-M" wrote:
I've boiled down a problem Function to the following statement:
=IF(I54=OR(2,3,4),"Low","")
I54 = 2
Function returns ""