ExcelBanter - ROUNDUP Function

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - ROUNDUP Function (https://www.excelbanter.com/excel-discussion-misc-queries/157106-roundup-function.html)

Chacky

ROUNDUP Function

Can I use ROUNDUP to round up to the nearest 5.

If the answer to a calculation is 52, I want to round up to 55.

I know that ROUNDUP(52, -1) will round up to the next 10 i.e. 60
but can you round up to the nearest 5

Ron Coderre

ROUNDUP Function

Try this:

=CEILING(A1,5)

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)

"Chacky" wrote in message
...
Can I use ROUNDUP to round up to the nearest 5.

If the answer to a calculation is 52, I want to round up to 55.

I know that ROUNDUP(52, -1) will round up to the next 10 i.e. 60
but can you round up to the nearest 5

All times are GMT +1. The time now is 01:43 AM.