Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Max,if,vlookup??
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Max,if,vlookup??
=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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|