You need to construct your formula like this:

=IF(A1=1,"Single",IF(A1=2,"Dual",IF(A1=4,"Quad","n one")))

Will return the message "none" if A1 does not contain 1, 2 or 4.

You can combine IF functions like this (referred to as nesting) up to
a maximum of 7 if you have XL2003 or earlier. An alternative way if
you have more than 7 criteria is to use VLOOKUP, or you could use
CHOOSE if your numbers are consecutive.

Hope this helps.

Pete

On Jul 7, 6:28*pm, 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