How do I make cells "If cell is blank then cell=0"in Excel 2000?

[Guest]

I am trying to make a spreadshet for a Nascar fantasy league but Excel does
not total blank cells. How do I get Excel to make the blank cells equal 0 so
they will total properly?

 

[JE McGimpsey]

Not quite sure what you mean - when totalling, a cell with zero will not
affect the total, nor will a blank.


If the cells are truly blank then using either

=A1+A2

or

=SUM(A1:A2)

will treat the blank cells as 0.

If instead, you've used the spacebar to "blank" the cell (i.e., inserted
text), then the + operator will give an error since it requires numeric
arguments. The SUM() will ignore text.