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

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(M3295,"CAND"," ") in another cell, but it returns a
value of CAND even when M32 is blank.

Thanks for your help
--
dbconn

Hi,

A bit shorter tan yours

=IF(AND(D5=5,D5<=12,M3295),"Eligible","")

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

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

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


"dbconn" wrote:

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

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(M3295,"CAND"," ") in another cell, but it returns a
value of CAND even when M32 is blank.

Thanks for your help
--
dbconn

Thanks for the help. I will try it


--
dbconn


"Mike H" wrote:

Hi,

A bit shorter tan yours

=IF(AND(D5=5,D5<=12,M3295),"Eligible","")

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

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

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


"dbconn" wrote:

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

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(M3295,"CAND"," ") in another cell, but it returns a
value of CAND even when M32 is blank.

Thanks for your help
--
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
--
dbconn


"Mike H" wrote:

Hi,

A bit shorter tan yours

=IF(AND(D5=5,D5<=12,M3295),"Eligible","")

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

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

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


"dbconn" wrote:

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

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(M3295,"CAND"," ") in another cell, but it returns a
value of CAND even when M32 is blank.

Thanks for your help
--
dbconn

You can clean up your 1st formula by using OR. Try taking the iserror part out of your M32 formula and I think you will see the problem. When formulas get to long its easier to troubleshoot one section at a time.