Adding columns with dates -
 

=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 -
1 or that they owe me one day labor - can you help ???
Thank you

Katherine

Adding columns with dates -
 

If there is no information in L30,M30,O30,P30, i.e. the cells are blank, the
formula returns zero just like you requested.

I can't comment on the rest of your formula as you produced that.


--
Regards,
Tom Ogilvy

"Katherine" wrote in message
...
=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 -
1 or that they owe me one day labor - can you help ???
Thank you

Katherine

Adding columns with dates -
 

=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 !! Is there anyone out there
tthat can tell me what is wrong with this formula? 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 -
1 or that they owe me one day labor - can you help ???
Thank you

Katherine

..