Forum Discussion

Copper Contributor

Feb 29, 2020

Round Down to the nearest 5

So my problem is 11600/3 = 3867, but I need it to round down to the nearest 5. How can I set my formula to do this??

Diamond Contributor

Mar 03, 2020

Just in case, to cover negative numbers

=MROUND(A1,SIGN(A1)*5)

=ROUND(A1/5,0)*5