IF Statements

Frank · Oct 8, 2003

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 · Oct 8, 2003

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 · Oct 9, 2003

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
-------------------------------------------

.