Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Vat formulas
I would like to be able to set up a template for my vat returns each month,
using the correct formulas for total, standard and vat. Can you please help |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Vat formulas
Hi Sandra
With Vat rate in A1 as a percentage e.g 17.5% for Standard or 5% for Lower If you want to go from Gross figure to Net of VAT figure, then with Gross in B1 =B1/(1+A1) If you want to Know the amount of VAT contained within the Gross figure then =B1-(B1/(1+A1)) If you are going from Net of VAT figure to Gross, then =B1*(1+A1) -- Regards Roger Govier "Sandra" wrote in message ... I would like to be able to set up a template for my vat returns each month, using the correct formulas for total, standard and vat. Can you please help |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Vat formulas
Roger
Thanks for your help but I am a complete beginner who has always hand written and worked out the vat by calculator. Recently my son said I should get excel because it would make life much easier. I am not particularly IT literate so its all very confusing for me. Thanks Sandra "Roger Govier" wrote: Hi Sandra With Vat rate in A1 as a percentage e.g 17.5% for Standard or 5% for Lower If you want to go from Gross figure to Net of VAT figure, then with Gross in B1 =B1/(1+A1) If you want to Know the amount of VAT contained within the Gross figure then =B1-(B1/(1+A1)) If you are going from Net of VAT figure to Gross, then =B1*(1+A1) -- Regards Roger Govier "Sandra" wrote in message ... I would like to be able to set up a template for my vat returns each month, using the correct formulas for total, standard and vat. Can you please help |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Vat formulas
Sandra,
Firstly put the VAT rate in a cell, say A1, as a percentage. For instance, type 17.5% in A1 Then, do you want to add the VAT to an amount? If so, assuming the amount is in B10, then in C10 add =ROUND(B10*$A$1,2) If you want to calculate the VAT in an amount? Again, assuming the amount in B10, then in C10 add =ROUND(B10-(B10/(1+A1)),2) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Sandra" wrote in message ... Roger Thanks for your help but I am a complete beginner who has always hand written and worked out the vat by calculator. Recently my son said I should get excel because it would make life much easier. I am not particularly IT literate so its all very confusing for me. Thanks Sandra "Roger Govier" wrote: Hi Sandra With Vat rate in A1 as a percentage e.g 17.5% for Standard or 5% for Lower If you want to go from Gross figure to Net of VAT figure, then with Gross in B1 =B1/(1+A1) If you want to Know the amount of VAT contained within the Gross figure then =B1-(B1/(1+A1)) If you are going from Net of VAT figure to Gross, then =B1*(1+A1) -- Regards Roger Govier "Sandra" wrote in message ... I would like to be able to set up a template for my vat returns each month, using the correct formulas for total, standard and vat. Can you please help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change column letters to correct ones in many formulas automatically? | Links and Linking in Excel | |||
how can i get formulas in excel to copy and paste? | Excel Worksheet Functions | |||
How to make Excel run limited number of formulas on a given worksh | Excel Discussion (Misc queries) | |||
Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |