Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Tried this formula, but it doesn't work...
=IF(B2="", [A2], [B2]) I THOUGHT the formula above basically was saying, "if B2 is null then put the A2 data in this field". Trying to calulate dates for tasks... Column A has the due date Column B has the actual completion date Column C should have the formula Column D should have the results of column C minus column A The idea is to show what tasks are late. For calculation purposes though (and ease of use for the end user) if there is no "Actual Completion Date" in the spreadsheet - in other words, if the task is still in progress, then I just want the number to return as zero. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calulating week # & Day # | Excel Worksheet Functions | |||
Calulating hours, minutes and seconds | Excel Worksheet Functions | |||
Conditional Linking and Formatting across worksheets to form Summary Page - Only pull/link non-null fields | Excel Worksheet Functions | |||
reducing Calulating time | Excel Discussion (Misc queries) | |||
Calulating Age Formula | Excel Worksheet Functions |