if condition
thanx alot
"David Biddulph" wrote:
=IF(X1<=Y1,"OK",IF(X1<=Z1,"MAYBE","NOT OK"))
I am assuming that the MAYBE condition should include Y<X, not Y<=X, as
you've included the equality in the OK condition.
I am assuming also that the =A in the NOT OK condition should be Z,
otherwise you have a further outcome to define for Z and <A.
--
David Biddulph
"Omar" wrote in message
...
plz advise how can u make an if condition rule were it does the following:
check the number in a cell (X) and if its <= (Y) have a result OK
if the number (X) is (Y)<=(X)=<(Z) have a result MAYBE
if the number (X) is =(A) have a result NOT OK,
|