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