Thread: Excel - working out net and vat?
View Single Post
Old 08-01-2011, 23:32   #2
haydnwalker
Inactive
 
Join Date: Jan 2007
Location: Doncaster, S. Yorks.
Age: 42
Services: TV:Sky+, BB:DRL VDSL2 40/10 with Ask4, Phone:Mobile Only
Posts: 2,320
haydnwalker has reached the bronze age
haydnwalker has reached the bronze agehaydnwalker has reached the bronze agehaydnwalker has reached the bronze agehaydnwalker has reached the bronze agehaydnwalker has reached the bronze agehaydnwalker has reached the bronze agehaydnwalker has reached the bronze agehaydnwalker has reached the bronze agehaydnwalker has reached the bronze agehaydnwalker has reached the bronze age
Re: Excel - working out net and vat ???
It should be pretty simple. However, are you entering the total and want to extract the net + VAT amounts from that?

eg: enter 100 in cell a1 and b1 gives the net and c1 gives the amount of VAT charged?

---------- Post added at 23:32 ---------- Previous post was at 23:30 ----------

Just googled and found this

Code:
Enter sale price in cell A1: 100.00

Enter VAT / Tax in cell A2: 18.00% 


Use the following function to calculate the net sale price: =A1/(100%+A2) 

The result: 84.75 


To calculate the VAT / Tax use the following function: =A1-A1/(100%+A2)

The result: 15.25
haydnwalker is offline   Reply With Quote