=IF(AND(N29=3,MAX(N9:N28)3,MAX(D9:D23)+365TODAY ()),"test","")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"edwardpestian"
wrote in message
news:edwardpestian.2a45v1_1151500505.2659@excelfor um-nospam.com...

I'm trying to have a cell return a string based on several criteria:

If the cell N29 = 3.0

If the Range N28:N9 =3.0 and IF the MAX Date + 365 in the Range D23:D9
is greater than today, return "test", otherwise "".

In other words, look at N29 and if its greater than 3.0, then look at
the range above it N28:N9 and if there is a value =3.0 and the maximum
date in Range D23:D9 + 365 is greater than today then return "test,"
otherwise return ""

I'm stuck on this one.

Thanks.

ep


--
edwardpestian
------------------------------------------------------------------------
edwardpestian's Profile:
http://www.excelforum.com/member.php...o&userid=33809
View this thread: http://www.excelforum.com/showthread...hreadid=556452