How do I ROUND UP to a whole number

In Excel workbook provided, I am trying to make Cells A7 and A8 ROUND UP to the next whole number. I know I can format cells A7 and A8 and remove the decimal places but the math still totals the Total Extended Cost in Column I. I know this is simple but I cannot figure it out.

My Goals is to have Cell A7 a 6 instead of 5.6 and cell A8 a 9 instead of 8.4.

Thanks

Try this:

=ROUNDUP(B3/100,0)

Try this:

Formula:

Please Login or Register  to view this content.

HTH
Tim

Haha! Jinx.

Glad to have helped, me and my echo!

Glad to have helped, me and my .... erm, nevermind.