View Single Post
Old 09-01-2011, 00:39   #12
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 ???

Quote:
Originally Posted by louise1989 View Post
i dont know if this will help but and the end of the file name it says xlsx im using excel 2010 is it not compatible with this website or something ??
No I don't think the office 2007/2010 formats are compatible here, you would need to do a File > SaveAs and change the type to xls (excel 2000-2003)

---------- Post added at 00:39 ---------- Previous post was at 00:37 ----------

Quote:
Originally Posted by Matt D View Post
So, with C2 = Net, D2 = VAT, & E2 = Total, & where you are starting with the Total -

C2 = E2/1.175

D2 = E2-C2

E2 = Whatever you enter

---------- Post added at 00:35 ---------- Previous post was at 00:34 ----------



It was to rogerdraig, because the net price, when VAT is 17.5%, isn't simply 82.5% of the final price.
@MattD: Confirmed by my upload above
haydnwalker is offline   Reply With Quote