Max,if,vlookup??

[edwardpestian]

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 D239
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 D239 + 365 is greater than today then return "test,"
otherwise return ""

I'm stuck on this one.

Thanks.

ep

 

[Bob Phillips]

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

--
HTH

Bob Phillips

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

"edwardpestian" <[email protected]>
wrote in message
news:[email protected]...