combine or if
=IF(A1=1, "Single",IF(A1=2, "Dual",IF(A1=4, "Quad","")))
--
Hope this helps.
If this post was helpfull, please remember to click on the ''''YES''''
button at the bottom of the screen.
Thanks,
Gary Brown
"littlelouise1" wrote:
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
|