Actually, much simpler:

=ROUND(A2/5,0)*5

--
Regards

Juan Pablo González

"Juan Pablo González" wrote in message
...
I think this should do it

=IF(CEILING(A2,5)-A2<=2.5,CEILING(A2,5),FLOOR(A2,5))

--
Regards

Juan Pablo González

"R-Enemy" wrote in message
...
I need to round numbers to the nearest 5 in VBA.

ex:

8 - 10
23 - 25
42 - 40

Any suggestions.

Thanks.