Rounding Problem

[sohaibj]

I want to round numbers to nearest 5. Like

Number Answer
121 120
123 125
126 125
127 125
128 130

 

[gingersteve]

=A1+IF(MOD(A1,5)>=2.5,5-MOD(A1,5),-MOD(A1,5))

 

[jindon]

try

=Ceiling(Int(A1)-2,5)

 

[onlyadrafter]

Hello,

TRy

=MROUND(K19,5)

 

[Jon von der Heyden]

Or yet another way:

=ROUND(A1/5,0)*5