Something along these lines might do the trick for you:

=IF(MOD(A1,0.5)=0,A1,A1+(0.05-MOD(A1,0.05)))
--
Kevin Backmann


"juanpablo" wrote:

If I have 8,64 and I need to round the number to 8,65?
Or if I have 3,21 and round the number to the nearest 5 to 3,25

How can be done?