VAT formulas

[Welshgar]

Hi,
Have searched on the forum bout can't find anything specific to what I want. I know its a simple one, but for the life of me cannot remember how I used to do it ( havent had a to use excel in my job until recently since i used to work in my old job)

I need to calculate the VAT total from an amount and also the net total

so something like this

Amount Net Total VAT Total

£xxxxx ????? ??????


with the VAT total being 20%

I know its simple, just for the life of me I cant remember, any help would be appreciated

Thanks
G

 

[meldoc]

Hello and welcome to MrExcel

Is it.

Excel Workbook
	A	B	C	D
1	Amount	Net Total	VAT Total	Vat
2	100.00	80.00	20.00	20%
Sheet1

Excel 2010

Cell Formulas
Range	Formula
B2	=A2-C2
C2	=A2*D2

 

[wigi]

Do you mean this?

In A1 is the amount. In B1:

=A1/(1+$A$2)

A2 is the VAT percentage (20%)

In C1:

=A1-B1

Wigi

 

[Welshgar]

i need the VAT as a separate amount, i will then need to deduct that separate amount from the total, but thats easy enough

 

[wigi]

Both suggestions calculate the VAT amount, so I do not understand why you say

i need the VAT as a separate amount

 

[Welshgar]

got it

Thanks for the help