Help with another formula, please

  • Thread starter Thread starter dbconn
  • Start date Start date
D

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
 
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.
 
Thanks for the help. I will try it


--
dbconn


Mike H said:
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.
Click to expand...
 
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
 
Back
Top