Thread: Excel - working out net and vat?
View Single Post
Old 09-01-2011, 15:25   #22
TheNorm
Inactive
 
TheNorm's Avatar
 
Join Date: Jun 2006
Location: Cambridge
Services: Sky TV, VM TV, 20meg bb, tel, and a lobster (but the lobster died).
Posts: 4,349
TheNorm has a nice shiny star
TheNorm has a nice shiny starTheNorm has a nice shiny starTheNorm has a nice shiny starTheNorm has a nice shiny starTheNorm has a nice shiny starTheNorm has a nice shiny starTheNorm has a nice shiny starTheNorm has a nice shiny starTheNorm has a nice shiny starTheNorm has a nice shiny starTheNorm has a nice shiny starTheNorm has a nice shiny starTheNorm has a nice shiny starTheNorm has a nice shiny starTheNorm has a nice shiny starTheNorm has a nice shiny starTheNorm has a nice shiny star
Re: Excel - working out net and vat ???
Quote:
Originally Posted by louise1989 View Post
Sorry can u say that again...!
1. Find the cell you want to round up.

2. If the formula in that cell is

=XXX

Then change this to

=ROUNDUP(XXX,2)

3. You are finished!
TheNorm is offline   Reply With Quote