View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_3_] Sheeloo[_3_] is offline
external usenet poster
 
Posts: 1,805
Default Formula assistance with subtracting percentages

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

"Denise B" wrote:

Formula:
=sum(A*B+C*D) then I want to subtract 20%. I have tried several ways and
cannot get it right.