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
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