Gary's Student Part 3 or Anyone else

O

ohnesorge

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.
 
D

Dave Peterson

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

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

David Biddulph

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Gary's Student part 2 or Question 2 on excel spreading Dates evenl 3
Formula for searching 3 criteria 4
Calculate difference in dates 11
Calculating Average based on 3 filled cells from left in a row 6
help with formula 3
Very interesting problem that should be a snap to figure out! 3
Formula for searching 3 different Criteria 1
Formula based on 3 criteria 3

Top