MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Rounding Up to the Next Whole Penny


Posted by Pat Smith on April 05, 2001 8:04 AM

I have a spread sheet that adds several different per hour charges and places them on a customer sheet. When the charges are calculated they come out 14.035463 which end up being 14.03 in stead of 14.04. is there a way to get it to round up to the next whole cent.


Posted by Mark W. on April 05, 2001 8:08 AM

=CEILING(14.035463,0.01)

Posted by Barrie Davidson on April 05, 2001 8:08 AM

Use the "roundup" function. The example below assumes your data is in cell A1.

=Roundup(A1,2)

Posted by Mark W. on April 05, 2001 8:28 AM

The CEILING() function is especially useful when
you want to round your prices to a particular
currency denomination. If you want your prices
rounded up to the nearst nickel you'd use
=CEILING(14.035463,0.01). Nearest quarter?
=CEILING(14.035463,0.25).

Posted by Mark W. on April 05, 2001 8:36 AM

Oops! Typo

The CEILING() function is especially useful when
you want to round your prices to a particular
currency denomination. If you want your prices
rounded up to the nearst nickel you'd use
=CEILING(14.035463,0.05). Nearest quarter?
=CEILING(14.035463,0.25).