Simple Excel help

[!GasAxe!]

Hi there,

What I am trying to do is this ( hope i can explain it easy):

Column A : insert figure ie 20 (format as money)
Column B : Add 17.5% (add the vat)
Column C : Add 20% to the sum of column B


what i tried is: in column b =sum(a1+17.5%) when using the figure 20 but it gives me 20.175 instead of 23.50

What am i doing wrong?

Cheers

Gas

 

[!GasAxe!]

A1+17.5% is just doing A1+0.175. You need to *1.175 or 117.5%, as said above.

Similarly, to add 20% in column C you need B1*1.2 (or B1 * 120%).

You didn't need Excel help, you needed Maths help(!)

Thanks for all your help,even though some of you are abit cheeky must admit maths was never my strong point at school and i left 17years ago !!!


Gas