How can I limit the value of blank cells

  • Thread starter Thread starter Glenn V.
  • Start date Start date
G

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
 
Hi Frank:

Did you mean:

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

?

And perhaps COUNT would be better ...

Regards,

Vasant.
 
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.
 
Back
Top