| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date Formula results in a #VALUE! Error
=IF(N562="Yes",P562+20,P562+45),IF(P562+45=45,S56 2+45) I have this formula in cell Q562 and I get a #VALUE Error!. The formula is referencing dates plus either 20 or 45 days. In the second part of the formula I'm trying to say if the date in P562 is equal to or greater than 45 days then take the date in S562 add 45 days to it and this is the new deadline date. I cannot find out what is wrong with this formula. Help??
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Random #VALUE! error in simple SUM formula results | Excel Worksheet Functions | |||
| Rounding date formula results | Excel Discussion (Misc queries) | |||
| Formula results in error - don't know why | Excel Discussion (Misc queries) | |||
| Trending Formula Results by Date | Excel Worksheet Functions | |||
| error on formula results | Excel Discussion (Misc queries) | |||
Threaded Mode
