ROUNDUP Function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Try this:

=CEILING(A1,5)

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

Regards,

Ron
Microsoft MVP (Excel)
 
Back
Top