C
Chris T-M
I've boiled down a problem Function to the following statement:
=IF(I54=OR(2,3,4),"Low","")
I54 = 2
Function returns ""
=IF(I54=OR(2,3,4),"Low","")
I54 = 2
Function returns ""
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Nested IF, reports incorrectly, can't find anything like it to ref
M
Michael
Try this:
=IF(OR(I54=2,I54=3,I54=4),"Low","")
=IF(OR(I54=2,I54=3,I54=4),"Low","")
R
Ron Coderre
Each component of the OR function must return a TRUE/FALSE value....
however, if those components return numeric values:
0=FALSE,
any other number=TRUE.
Consequently, OR(2,3,4) is equal to OR(TRUE, TRUE, TRUE)
Try on of these:
=IF(OR(I54=2,I54=3,I54=4),"Low","")
or
=IF(OR(I54={2,3,4}),"Low","")
Does that help?
--------------------------
Regards,
Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
however, if those components return numeric values:
0=FALSE,
any other number=TRUE.
Consequently, OR(2,3,4) is equal to OR(TRUE, TRUE, TRUE)
Try on of these:
=IF(OR(I54=2,I54=3,I54=4),"Low","")
or
=IF(OR(I54={2,3,4}),"Low","")
Does that help?
--------------------------
Regards,
Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
C
Chris T-M
Duh! Thank you very much.
Now if I can just simplify 21 nested IF statements into 7 I'll be set.
Now if I can just simplify 21 nested IF statements into 7 I'll be set.
C
Chris T-M
Thank you also. They both work, but the second is less "wordy"
J
JMB
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 here:
http://www.cpearson.com/Excel/nested.htm
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 here:
http://www.cpearson.com/Excel/nested.htm
I
ilia
What are the statements?
Duh! Thank you very much.
Now if I can just simplify 21 nested IF statements into 7 I'll be set.
- Show quoted text -