Simple Excel help

!GasAxe! · 8 May 2007 at 09:49

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

MarcLister · 8 May 2007 at 10:26

When working out VAT I normally do something like =SUM(A1*117.5%). You are adding 17.5% whereas I think you need to multiply by 17.5% or 117.5% in order to reach the VAT target.

csmager · 8 May 2007 at 10:31

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(!)

MarcLister · 8 May 2007 at 10:34

csmager said:
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(!)

Blimey!! I got a maths question right?! I'll have to ring my Mum; she won't believe me though.

!GasAxe! · 8 May 2007 at 10:53

csmager said:
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