Hi,

I think this is what you want

=IF(AND(D5=5,D5<=12,AND(M32<"",M32=96)),"Eligib le","")

Note when doing these yourself you seem to have a (bad) habit if inserting a
space
" " instead of a null string "" for the false condition. As a general rule
it is better to return a NULL string for your false condition.
--
Mike

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


"dbconn" wrote:

Mike,
Earlier today you gave me the following formula
=IF(AND(D5=5,D5<=12,M3295),"Eligible","") intended to return a value of
Eligible if D5 was =5 and ,=12 AND M32 is 95. I changed it slightly to
=IF(AND(D5=5,D5<=12,M32=96),"Eligible","") so that a value like 95.5 would
not work.

I have found that I get the ELIGIBLE value when I enter a valid number in
D5, even when M32 is still blank. M32 has a formula in in as follows
=IF(ISERROR(AVERAGEIF(M14:M28,"<0",M14:M28)),"
",AVERAGEIF(M14:M28,"<0",M14:M28))

Is there a way to change the formula you gave me so that ELIGIBLE will only
return if D5 is between 5 and 12 AND there is an actual value in M32 that is
=96?

Thanks much
--
dbconn