Round in multiples of 5

[zelarra821]

Good afternoon. I need to round up to the top multiple of 5, but none of the Excel functions work for me.

I put what I want to achieve:

1.20 -> 1.20

1.21 -> 1.25

1.22 -> 1.25

1.23 -> 1.25

1.24 -> 1.25

1.26 -> 1.30

1.27 -> 1.30

1.28 -> 1.30

1.29 -> 1.30

I do not know if functions can be achieved or will have to make a custom formula.

Thank you.

[queuesef]

if your number to convert is in Cell A1, then copy the following formula in Cell B1

Please Login or Register  to view this content.

(if want the formula in another cell, say d1, then just copy the formula to D1

[zelarra821]

Thanks a lot. Solved