IF OR help

D

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
 
P

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
 
P

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
 
M

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.
 
M

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.
 

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

Help with another formula, please 3
For Mike H 2
Sumproduct where cell values are the same in a sorted column 1
Formulas 3
formula help 3
NOW() help 2
problem with indirect 7
This One Is Tricky Need Help !!!!! 1

Top