Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
In using the following formula I encounter a problem - if
the columns have no information a -1 appears in the total - is there a way to use this formula and have it recognize when all cells are empty ? Help thanks - example of what I am trying to accomplish below Column A B C D E F G 03/03/04 03/03/4 1 03/03/04 03/05/04 3 3 -1 03/03/04 03/03/04 1 1 03/03/04 03/04/04 2 2 03/03/04 03/04/04 2 03/05/04 03/07/04 3 5 Explanation My formula has to recognize the first date as day 1 and if in and out day are the say in the subtraction it is one not zero - (it is accomplishing this) it must also recognize that if column B & D are the same D can not be counted (it is doing this) the problem is when the cells are completely empty the formula is giving me a total of - 1 or that they owe me one day labor - can you help ??? Thank you Katherine |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Advanced Query not returning correct results?! | Excel Discussion (Misc queries) | |||
Getting correct results for lookup? | Excel Discussion (Misc queries) | |||
what formulas will give correct results | Excel Discussion (Misc queries) | |||
How do I get correct results when LOOKUP with calculated numbers | Excel Worksheet Functions | |||
My IF(AND passes logical, but doesn't reveal correct results | Excel Worksheet Functions |