Gary's Student Part 3 or Anyone else
 

I might not have explained correctly, sry for that If A1=12/10/08, and i
input a compltetion date B1=12/11/08= my answer in C1= (1) which is correct.
My Question is that how do i make C1 display ZERO instead of 39796. if i do
not enter a number into B1, C1 comes up 39,796 which is a problem when i am
trying to add the total amount of days we are behind or on schedule.

Gary's Student Part 3 or Anyone else
 

You could check to see if the number of entries with dates/numbers is 2:

=if(count(a1:b1)<2,"",yourformula)




ohnesorge wrote:

I might not have explained correctly, sry for that If A1=12/10/08, and i
input a compltetion date B1=12/11/08= my answer in C1= (1) which is correct.
My Question is that how do i make C1 display ZERO instead of 39796. if i do
not enter a number into B1, C1 comes up 39,796 which is a problem when i am
trying to add the total amount of days we are behind or on schedule.

--

Dave Peterson

Gary's Student Part 3 or Anyone else
 

Hi,
do
=if(B1=0,0,A1-B1)
hope this help

"ohnesorge" wrote:

I might not have explained correctly, sry for that If A1=12/10/08, and i
input a compltetion date B1=12/11/08= my answer in C1= (1) which is correct.
My Question is that how do i make C1 display ZERO instead of 39796. if i do
not enter a number into B1, C1 comes up 39,796 which is a problem when i am
trying to add the total amount of days we are behind or on schedule.

Gary's Student Part 3 or Anyone else
 

If this is supposed to be following on from some previous thread, you ought
to reply to that thread and quote enough of the previous message(s) to put
your reply into context.
I guess you might want something like =IF(B1="",0,your_formula), but we
can't be sure without knowing what you are trying to do.
--
David Biddulph


"ohnesorge" wrote in message
...
I might not have explained correctly, sry for that If A1=12/10/08, and i
input a compltetion date B1=12/11/08= my answer in C1= (1) which is
correct.
My Question is that how do i make C1 display ZERO instead of 39796. if i
do
not enter a number into B1, C1 comes up 39,796 which is a problem when i
am
trying to add the total amount of days we are behind or on schedule.