Forum Discussion

jshea23's avatar
jshea23
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??

2 Replies

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor

    jshea23 

    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)

     

Resources