VAT calculations

[srug51]

Can any one please let me have the formula for 18% vat?

I know that 17.5% vat is =*7/47
15% vat is = *3/23

What is 18%?:confused

 

[Norman Harker]

Hi srug51:

To add VAT use:

=A1*(1+18%)

To find net of VAT amount use:

=A1/(1+18%)

To find the VAT content

=A1-A1/(1+18%)
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Henry]

srug51,

try *18/100 or *9/50 or *0.18

17.5% is *7/40 NOT *7/47. You could use *0.175

15% is *3/20 NOT *3/23. You could use *0.15

HTH
Henry

 

[Frank Kabel]

Hi
if A1 stores your base value use something like:
1. To calculate the VAT:
=A1*0.18

2. To calculate the base value + VAT
=A1*(1+0.18)


3. To get the included VAT use
=A1-A1/(1+0.18)

 

[Henry]

Frank,

1 + 0.18 = 1.18
So No.2 can be reduced to A1*1.18
and No.3 reduced to A1- A1/1.18

ATB
Henry

 

[Frank Kabel]

Hi Henry
correct but I separated both values to make it clearer for the OP

 

[RK]

Using your same rationale, 18% vat is *9/59

 

[Henry]

No. 3 can be reduced further to A1 * 0.15254237288135593220338983050847
(number copied & pasted from Calculator. I know it exceeds the Excel 15
places limit)
However, this isn't an easy number to remember!
Perhaps we'd be better to stay with A1- A1/1.18?

ATB
Henry

 

[srug51]

Thanks guys, you have all been a great help. :