Formula assistance with subtracting percentages

  • Thread starter Thread starter Denise B
  • Start date Start date
D

Denise B

Formula:
=sum(A*B+C*D) then I want to subtract 20%. I have tried several ways and
cannot get it right.
 
Hi Denise
Would that work for you ? =SUM(A1*B1+C1*D1)*0.8
I think you left out the row numbers in your formula.
HTH
John
 
When you subtract 20% from a number then you are left with 80% so multiply by
0.8

=Sum(A1*B1+C1*D1)*0.80

Will give you 80% of AB + CD
 
Back
Top