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