Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lookup with multiple condition, but one condition to satisfy is en | Excel Worksheet Functions | |||
Combine an OR condition with an AND condition | Excel Discussion (Misc queries) | |||
Condition Sum | Excel Worksheet Functions | |||
Condition 1 overules condition 2? | Excel Worksheet Functions | |||
How to set condition: A1=A2=A3= ... =A10 | Excel Worksheet Functions |