Thread: Excel - working out net and vat?
View Single Post
Old 09-01-2011, 18:59   #26
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
woohooo managed to get the vat to work out right after much fidderling about right next question can i make the net and vat automatically round up to the nearest penny ??
Right click on the cells you want to round to the nearest penny and choose "format cells" and click on the number tab and change the decimal places to 2 that should be it - no calculations necessary.

OR do the same right click etc and set the number format to currency
haydnwalker is offline   Reply With Quote