combine or if
You can use
=VLOOKUP(A1,{1,"Single";2,"Dual";3,"Quad"},2,0)
which is handy especially if you use more than 3, or
=CHOOSE(A1,"Single","Dual","Quad")
if you insist using IF
=IF(A1=1,"Single",IF(A1=2,"Dual","Quad"))
assuiming thatn there cannot be any other values than 1,2,3
--
Regards,
Peo Sjoblom
"littlelouise1" wrote in message
...
I need to check for three (or more conditions) and need a different value
returned for each criteria.
For example:
DATA Wanted result:
1 Single
2 Dual
4 Quad
My mistake lies in formatting of the formula:
If(A1=1, "Single")or if(A1=2, "Dual") or if (A1=4, "Quad")
-aimes
|