IF OR help

[dbconn]

I have entered the formula
=IF(OR(D5="K",D5<=4,M32<=95),"INELIGIBLE"," ")

I am trying to get a result that will display INELIGIBLE when the value in
D5 is K,1,2,3,4 OR the value in M32 is less than 96. with this formula I now
get INELIGIBLE when D5 is blank.

I would like cell to be blank unless one of the specific conditions is met.
If either D5 or M32 is blank, I would like this cell to also be blank M32
contains a formula that returns a blank cell unless data is entered elsewhere
in the workbook

Thanks for all the help

 

[Pete_UK]

Try this:

=IF(OR(K5="",M32="","",IF(OR(D5="K",D5<=4,M32<=95),"INELIGIBLE",""))

Note that I have also removed the space between your " " at the end of
the formula - that would not return a blank.

Hope this helps.

Pete

 

[Pete_UK]

Sorry, I missed a closing bracket:

=IF(OR(K5="",M32=""),"",IF(OR(D5="K",D5<=4,M32<=95),"INELIGIBLE",""))

Hope this helps.

Pete

 

[Mike H]

try this

=IF(AND(OR(D5="K",D5<=4,M32<=95),D5<>""),"INELIGIBLE"," ")

--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.

 

[dbconn]

Thanks for your help on this and on the earlier "eligible" result

 

[Mike H]

OOPs

the last one was wrong, try this instead

=IF(OR(D5="K",AND(D5<>"",D5<=4),AND(M32<=95,M32<>"")),"INELIGIBLE","")
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.