Rounding up:create a formula

[melfarmer]

Hi

Hoping someone will be able to help me again - am trying to create a formula that will allow me to round numbers to the nearest multiple of 5. For example $22 up to $25, $217 up to $220 etc whilst leaving those numbers that are already a multiple as they are.

Any ideas??

Thanks

[daddylonglegs]

If your number is in A1 try this formula

=CEILING(A1,5)

[shg]

Your title says round up, and your post says nearest multiple -- which?

[melfarmer]

Brilliant - thanks again daddylonglegs, works like a treat!!!!