Calculating VAT of Gross amount

Boomtastic · 2008-04-23 13:47:16

How do I determine what the VAT (21%) is from the Gross figure? I'm trying to write a spreadsheet calculation. Example: If the Gross figure is €900 how do I calculate that the VAT on that amount is €156.20 and the Net figure is €743.80? My brain hurts..... :)

23-04-2008 02:47PM

#1

Boomtastic

Closed Accounts Posts: 59 ✭✭

Join Date: August 2006

Posts: 46

How do I determine what the VAT (21%) is from the Gross figure?

I'm trying to write a spreadsheet calculation.

Example:
If the Gross figure is €900 how do I calculate that the VAT on that amount is €156.20 and the Net figure is €743.80?

My brain hurts.....

0

Comments

#2 23-04-2008 04:16PM

Jakey

Closed Accounts Posts: 105 ✭✭

Join Date: January 2007

Posts: 99

To get the net from the gross divide by 1.21 (for 21% Vat)
=900/1.21 will give you the net amount

=A1/1.21 (if you put the gross amount in cell A1)

To calculate the vat amount subtract the net from the gross

Good Luck

0
#3 23-04-2008 04:18PM

Boomtastic

Closed Accounts Posts: 59 ✭✭

Join Date: August 2006

Posts: 46

Yep, Jakey just figured it out. Thanks for your help anyways.

0