Simple Percentage Formula!

[bobzy20]

Hi,

I can’t seem to work this out.

I’m looking for an excel formula to calculate the following.

Column A - £10
Column B is the formula = x Column A by 10.9% + £0.30 x everything by 20%

I have the following: =SUM(A1*10.9%)+0.3 but can’t seem to add the 20% part, as it should calculate at £5.59 and I get £4.72.

Any help would be great.

Thanks in advance

 

[arthurbr]

Your formula returns 1.39 to be multiplied by 1.2 which returns 2.59 which is no where near your expected result???

 

[bobzy20]

Oh yes, sorry, A1 has a value of £39.99 not £10!

 

[Fluff]

How about

=(A2*0.109+0.3)*1.2

 

[bobzy20]

How about

=(A2*0.109+0.3)*1.2

Perfect, thanks so much!

 

[Fluff]

Glad we could help & thanks for the feedback.