Quote:
Originally Posted by TheNorm
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!
|
Much better I will try that when I get home thanks !
---------- Post added at 17:34 ---------- Previous post was at 17:32 ----------
Quote:
Originally Posted by Lord Nikon
Don't forget to adjust the calculations to account for the new VAT rate of 20% though.
|
Yes I know im doing last quater at the moment so I needed the 17.5% and when I do this quater I just need to change the formular to the new tax rate correct?