ExcelBanter - ROUNDUP NUMBER

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - ROUNDUP NUMBER (https://www.excelbanter.com/excel-worksheet-functions/137188-roundup-number.html)

Bee

ROUNDUP NUMBER

I would like to roundup a number in Excel to the nearest 50 cents. I know it
is possible to roundup to whole numbers and nearest 10 cents but I need to
round up by 50 cents if this is possible.

Any help is much appreciated!

Thank you in advance!

Bee

ROUNDUP NUMBER

I have worked it out with the following formula!!!

=CEILING(cell reference,0.5)

"Bee" wrote:

I would like to roundup a number in Excel to the nearest 50 cents. I know it
is possible to roundup to whole numbers and nearest 10 cents but I need to
round up by 50 cents if this is possible.

Any help is much appreciated!

Thank you in advance!

Ron Rosenfeld

ROUNDUP NUMBER

On Thu, 29 Mar 2007 16:06:02 -0700, Bee wrote:

I would like to roundup a number in Excel to the nearest 50 cents. I know it
is possible to roundup to whole numbers and nearest 10 cents but I need to
round up by 50 cents if this is possible.

Any help is much appreciated!

Thank you in advance!

=CEILING(A1,0.5)
--ron

All times are GMT +1. The time now is 10:36 PM.