Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Gary's Student part 2 or Question 2 on excel spreading Dates evenl | Excel Discussion (Misc queries) | |||
Map Network Drive FAO Gary's Student | Excel Discussion (Misc queries) | |||
To Gary's Student | Excel Discussion (Misc queries) | |||
To: Gary's Student cell address reply | Excel Discussion (Misc queries) | |||
Is Gary's Student here | Excel Discussion (Misc queries) |