Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function returning unexpected value
I am using Excel 2007.
I have the function: =IF(AND(ISBLANK(Milestones[[#This Row],[Actual Completion Date]]),ISBLANK(Milestones[[#This Row],[Updated Projection Date]])),TODAY()-Milestones[[#This Row],[Baseline Planned Date]],IF(AND(ISBLANK(Milestones[[#This Row],[Actual Completion Date]]),(ISBLANK(Milestones[[#This Row],[Updated Projection Date]]=FALSE))),TODAY()-Milestones[[#This Row],[Updated Projection Date]],Milestones[[#This Row],[Actual Completion Date]]-Milestones[[#This Row],[Baseline Planned Date]])) I am expecting to get the value of 5 (today - 7/17/2009). Instead, I am getting -39992. Can anyone help me find where I am going wrong? I have looked for so long that I am unable to locate my error. Thank you, -- Paul |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MOD function not returning exact zero | Excel Worksheet Functions | |||
FV Function result is unexpected. | Excel Worksheet Functions | |||
Unexpected Function | Excel Worksheet Functions | |||
The ispmt function is providing unexpected results | Excel Worksheet Functions | |||
Returning colours from a function | Excel Worksheet Functions |