IF Statements

[Frank]

I know this can be done I've just forgotten;

basically I want to say "IF(cell refrences is less than
or equal to x, then return z, if it's less than y but
greater than x, then retun zz, if it is greater than y,
then return zzz).

Thanks in advance!

 

[Earl Kiosterud]

Frank,

IF(A2<=x, z, IF(A2<y, zz, zzz))

You don't say about the case of A2 = y. YOu may have to use <= instead of
<.

 

[Frank]

Thanks!

-----Original Message-----
Frank,

IF(A2<=x, z, IF(A2<y, zz, zzz))

You don't say about the case of A2 = y. YOu may have to use <= instead of
<.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------




.