Value Added Tax - Rounding up)

[stuart_sims]

Hi all,

I am after a bit of help. I have created some timesheets on Excel.
These have costs and total payments and all work fine.

However, I have added a VAT cell at the bottom of my totals and if the
total is say a .5 then excel doesn't seem to round up the number. or
round it down if it's below .5.

If anyone has a piece of advice they would like to share you'd be
saving me so much time each week.

Thanks for reading.



------------------------------------------------


-- View and post Excel related usenet messages directly from http://www.ExcelTip.com/forum
at http://www.ExcelTip.com/
------------------------------------------------

 

[Nick]

hi there

you want to use the formula for wages

= roundup((Cell with Hrs) x (Wage per Hr) x (1 + VAT)),0)

cheers
nick

-----Original Message-----
Hi all,

I am after a bit of help. I have created some timesheets on Excel.
These have costs and total payments and all work fine.

However, I have added a VAT cell at the bottom of my totals and if the
total is say a .5 then excel doesn't seem to round up the number. or
round it down if it's below .5.

If anyone has a piece of advice they would like to share you'd be
saving me so much time each week.

Thanks for reading.

from http://www.ExcelTip.com/forumat http://www.ExcelTip.com/