if condition
 

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,

if condition
 

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

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,