wrote in message
...

-----Original Message-----
"Theo" wrote in
message
...
Is there a function available that will interpret a
blank
cell as 0?

In most cases this happens by default.
For example, if A1, A2 and A3 contain the numbers 1, 2
and 3, whilst A4:A10
are blank, then
=SUM(A1:A10)
will return 6.

Post again if you have a specific requirement to which
this doen't apply.


.
Suppose I have 3 cells
Normally the values are filled
10
10
10

I then have a 4th cell that add them together not using
the sum i.e. +c1+c2+c3 the total then would be 30

if the values are
10

10

using the same formula I would then get a #Value error
since the cell is blank. I want Excel to interpret the
blank cell as 0.

Thanks

No. If the cell is truly blank, you will get the correct result (i.e. 20).
If you get the #VALUE! error it means that the cell is not blank; it may
contain a space character or something, which is making it appear to the
formula as text.

You can test to see if the cell is truly blank using the formula
=ISBLANK(C2)
which will return TRUE if it is blank.