How can I limit the value of blank cells

[Glenn V.]

If I have values entered for a1, b1, and c1
then the sum of each value minus 10 is correctly
calculated in d1. When one of the values is not entered my
answer is 10 less than it should be.
The formula i'm using in d1 is:
=(a1-10)+(b1-10)+(c1-10)
how can

 

[Frank Kabel]

Hi
try
=SUM(A1:C1)-COUNTA(A1:B1)*10

 

[Vasant Nanavati]

Hi Frank:

Did you mean:

=SUM(A1:C1)-COUNTA(A1:C1)*10

?

And perhaps COUNT would be better ...

Regards,

Vasant.

 

[Glenn V.]

I'm gonna give this a try, Thank you very much.
I accidently pressed the wrong key and it posted my
question before I was done entering the info, so I re-
posted the same question with more info. But I think this
could be the right answer anyway.
Thanks again.

 

[Frank Kabel]

Hi Vasant
thanks for the correction - it was a little bite late for me