Help with another formula, please

[dbconn]

I currently have the following formula
=IF(D5=5,"ELIGIBLE",IF(D5=6,"ELIGIBLE",IF(D5=7,"ELIGIBLE",IF(D5=8,"ELIGIBLE",IF(D5=9,"ELIGIBLE",IF(D5=10,"ELIGIBLE",IF(D5=11,"ELIGIBLE",IF(D5=12,"ELIGIBLE"," "))))))))

I would like to add an additional condition wherein M32 must also be greater
than 95 in order to return "ELIGIBLE", otherwise return a value of a blank
cell.

M32 contains the formula =IF(ISERROR(AVERAGEIF(M14:M28,"<>0",M14:M28)),"
",AVERAGEIF(M14:M28,"<>0",M14:M28))

I have tried using =IF(M32>95,"CAND"," ") in another cell, but it returns a
value of CAND even when M32 is blank.

Thanks for your help

 

[Mike H]

Hi,

A bit shorter tan yours

=IF(AND(D5>=5,D5<=12,M32>95),"Eligible","")

or if you want to eliminate decomals in D5 the slightky longer

=IF(AND(D5>=5,D5<=12,MOD(D5,1)=0,M32>95),"Eligible","")
--
Mike

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

 

[dbconn]

Thanks for the help. I will try it


--
dbconn

Hi,

A bit shorter tan yours

=IF(AND(D5>=5,D5<=12,M32>95),"Eligible","")

or if you want to eliminate decomals in D5 the slightky longer

=IF(AND(D5>=5,D5<=12,MOD(D5,1)=0,M32>95),"Eligible","")
--
Mike

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

 

[dbconn]

Mike H,

Your formula worked great. Maybe you can help with another question?
In another cell, using your suggestion, 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 balnk.

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

Thanks