View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
John[_22_] John[_22_] is offline
external usenet poster
 
Posts: 694
Default Formula assistance with subtracting percentages

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
"Denise B" <Denise wrote in message
...
Formula:
=sum(A*B+C*D) then I want to subtract 20%. I have tried several ways and
cannot get it right.