Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
nested if statment - needs if(isna
I have the following formula, which works fine. It returns either the date, or the word current if the date is <=5 from today. IF(((TODAY())-(VLOOKUP($A$3:$A$126,Cons!$C$3:$F$8770,4,FALSE)))< =5,"Current",(VLOOKUP($A$3:$A$126,Cons!$C$3:$F$877 0,4,FALSE))) My issue is that if there is no date for the selection in my vlookup, it returns #n/a. I would like to get rid of that. I have added the if(isna(vlookup...), however, then it returns either the word True to False. I have also tried =if(isna(IF(((TODAY())-(VLOOKUP($A$3:$A$126,Cons!$C$3:$F$8770,4,FALSE)))< =5,"Current",(VLOOKUP($A$3:$A$126,Cons!$C$3:$F$877 0,4,FALSE))), with no results. Any assistance would be greatly appreciated. -- techiemom60 ------------------------------------------------------------------------ techiemom60's Profile: http://www.excelforum.com/member.php...o&userid=20124 View this thread: http://www.excelforum.com/showthread...hreadid=526351 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nested Subtotals in Excel 2002 | Excel Discussion (Misc queries) | |||
Why are my nested sub-totals are displaying incorrectly? | Excel Discussion (Misc queries) | |||
Nested IF statements | Excel Worksheet Functions | |||
Q: Nested if | Excel Discussion (Misc queries) | |||
nested ifs | Setting up and Configuration of Excel |