using IF to return text if the reference cell is blank

I am working on a sheet and I need a particular cell to return text dependant on whether certain conditions are met, thus far I have written this formula:

=IF(O15<K15,"NO",IF(O15>J15,"NO",IF(O15<J15,"YES",IF(O15=J15,"YES",IF(O15,"","N/A")))))

The first 4 "IF's" return what they're suppose to however the last IF should return a "N/A" because the cell [referenced] is blank - but it doesn't it returns "NO"

can anyone help me please

Try this formula

=IF(O15="","N/A",IF(OR(O15>J15,O15<K15),"NO",IF(O15<=J15,"Yes","")))

First:

You should consider using And within the if statement if you are have more than 1 criteria: If (And(a1>1,a1<5), "Good", if(.....

Thna for ur problem the last if statement you have is missing something: you wrote If(O15,"", "N/A") ...If O15 what?? u mean if O15 = 0 ..If O15 = " " ) do that and it should work fine.

Originally Posted by Bryan Hessey

Hi,

try

=IF(O15="","#N/A",IF(OR(O15<K15,O15>J15),"NO","YES"))))

in your example the first condition tested was true, thus 'NO' was the answer.

hth
---

This formula did exactly what it said on the tin !

thanks very much