Forum Discussion
jshea23
Feb 29, 2020Copper Contributor
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??
2 Replies
Sort By
- SergeiBaklanDiamond Contributor
- Riny_van_EekelenPlatinum Contributor
This could be (assume A1 contains the number you want to round):
=INT(A1/5)*5
This will always round to the previous multiple of 5 (i.e. rounding down). If your intention is to round to the nearest multiple of 5 it could be:
=MROUND(A1,5)