I need help calculating blank cells

[Glenn V.]

This is hopefully an easy question.
When a1, b1, and c1 have values entered the sum in d1 is
correct. When any of these cells are empty my answer is 10
less than I want. I would like to have the value of each
cell subtract 10 when it calculates the total. When a cell
is left blank I do not want it to subtract 10.

I think I need some type of if statement for d1 so it
won't subtract 10 when I'm leaving any of the a1, b1, c1
cells blank.

The current formula in d1 is:
=(a1-10)+(b1-10)+(c1-10)

Can someone please help me?

 

[Katherine Coombs]

Hi Glenn,

does this work for you?

=IF(OR(A1="",A1=0),A1,A1-10)+IF(OR(B1="",B1=0),B1,B1-10)+IF(OR(C1="",C1=0),C
1,C1-10)

I'm not sure if this is what you're after, in that it subtracts 10 from A1
if it's not empty, without regard for whether B1 and/or C1 are empty. Let
me know if this isn't what you're after.

HTH,
Katherine

 

[Debra Dalgleish]

The following formula sums the amounts in A1:C1, then deducts 10 for
each of the entries:

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