How do I round a number to a multiple of 5 for example?

Discuss
1

I’m creating a formula and I can’t round to a multiple of 5, could someone help me?

2

You mean if you have 31 you want to write 30 ? Always the lower multiple? One way could be 31/5= 6.2 round it ( 6 ) and do again 6x5 =30

2 Likes