Help with multiplication part of formula

  • Thread starter Thread starter ss
  • Start date Start date
S

ss

Up to this point the formula works ok.

(D20+I20)-(C20+H20)*0.16

The answer to the above is £112
I now want to add on 5% which should give me £117
So I changed the formula to

(D20+I20)-(C20+H20)*0.16*105%

But it returns £111

How do I alter the *105% part to give the correct return.

thanks
 
Hi,

Am Mon, 14 Jul 2014 12:59:53 +0100 schrieb ss:
Up to this point the formula works ok.

(D20+I20)-(C20+H20)*0.16

The answer to the above is £112
I now want to add on 5% which should give me £117
Click to expand...

try:
=(D20+I20-(C20+H20)*0.16)*1.05


Regards
Claus B.
 
Back
Top