Help with multiplication part of formula

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
 
C

Claus Busch

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help on an IF formula 3
Copy formula help 2
How do I stop #DIV/0! when some of my values are zero? 3
Same formula one not calculating properly? 2
How can I get around 30 argument limit of SUM function? 4
Help with multiplication formula 1
I need a little help with a formula 5
MIN and IF functions return no value if there is no date 4

Top