if condition

  • Thread starter Thread starter Omar
  • Start date Start date
O

Omar

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(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.
 
thanx alot

David Biddulph said:
=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.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CONDITIONAL SUM ("OR") 14
Determine a result of one column based on conditions in two column 1
array or IF formula excel help 2
Conditional Formatting 1
Sumproduct using and, and or 2
Conditional formatting using nested "Or(and ..." 6
transpose rows to column (cell) 3
Sum rows if muliple cells meet criteria but not others 4

Back
Top