I need to write a formula for excel that will work out VAT ( and I'm rubbish at maths) :
if A1 = VAT rate
A2 = price b4 VAT
A3 = Price Inc. VAt Then ...
In A3 I write the formula:
=SUM( A2 + A1)
? Doesn't work - PLEASE, where am I going wrong?
Printable View
I need to write a formula for excel that will work out VAT ( and I'm rubbish at maths) :
if A1 = VAT rate
A2 = price b4 VAT
A3 = Price Inc. VAt Then ...
In A3 I write the formula:
=SUM( A2 + A1)
? Doesn't work - PLEASE, where am I going wrong?
A3 = ((A1 + 100) / 100) * A2
e.g.
Price Before VAT = 50.
VAT = 14%
Therefore Price inc. VAT = 50 * ((14 + 100) / 100)
many thanks