Is there someone who can tell me what is wrong with my
formula below and how I would fix it - there is detailed
explanation of what I am trying to accomplish -- I sure
would appreciate it -- Thank you ! Katherine


=IF(countA(L30,M30,O30,P30)=0,0,IF(M30=O30,N(Q30)+ N(N30)-
1,N (Q30)+N(N30)))
The above formula does not work - it gives me "# null" in
the column if there should be a total and the -1 is still
there when there is not information in the columns as
shown below in row 2 - HELP !! I sure appreciate it ! I
am at a total loss on this one


Previous quest below:

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 ? IF(M30=O30,N(Q30)+N(N30)-1,N
(Q30)+N(N30)) 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
negataive 1 or that they owe me one day labor - can you
help ???
Thank you

Katherine

I can't get it to return #NULL, but in any event, remove the space from N
(Q30) so it is N(Q30) and see if that helps.

--
Regards,
Tom Ogilvy

"Katherine" wrote in message
...
Is there someone who can tell me what is wrong with my
formula below and how I would fix it - there is detailed
explanation of what I am trying to accomplish -- I sure
would appreciate it -- Thank you ! Katherine


=IF(countA(L30,M30,O30,P30)=0,0,IF(M30=O30,N(Q30)+ N(N30)-
1,N (Q30)+N(N30)))
The above formula does not work - it gives me "# null" in
the column if there should be a total and the -1 is still
there when there is not information in the columns as
shown below in row 2 - HELP !! I sure appreciate it ! I
am at a total loss on this one


Previous quest below:

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 ? IF(M30=O30,N(Q30)+N(N30)-1,N
(Q30)+N(N30)) 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
negataive 1 or that they owe me one day labor - can you
help ???
Thank you

Katherine