How do I stop Excel from treating blank cells as zero?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm calculating the difference between two dates, such as

A1 - 1st September
B1 - 10th September

So B1-A1 returns 9, which is great.

But I only enter the dates in column B when a certain visit has been made,
and while the cells in B are blank, Excel treats them as zero (or 1st Januray
1900). So B1-A1 returns -39000 odd.

Is there a way to essentially stop it from calculating the formula until
both cells have a value entered?
 
Hi Michael
Try
=IF(OR(A1="",B1=""),"",B1-A1)

Regards

Roger Govier
 
You must log in or register to reply here.

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

Networkdays and misleading results from blank column 3
Formulae returning blanks 5
Average formula where blank cells are counted as zeros 4
Function to treat formula result as blank cell 3
blank cells are treated as zeros how do I stop that 4
Return Blank from Cell Calculation 2
Need blank cells to remain empty 7
How do I put a blank value in a cell not using "" in a formula 2

Back
Top