How to round value to a multiple of an integer in Google Sheets?

How to make a specific cell (B2) from all sheets to automatically rounddown the input number to the nearest multiple of 4 integer?

Example. When I input a number in cell B2 (33.33), it need to be rounded down to the nearest multiple of 4 integer (32).

If possible, i want that code works for all sheets. What script codes should I use?

16 thoughts on “How to round value to a multiple of an integer in Google Sheets?”

  1. I have been exploring for a little bit for any high quality articles or weblog posts on this sort of space .
    Exploring in Yahoo I eventually stumbled upon this site.
    Reading this information So i’m glad to exhibit that I have a very
    good uncanny feeling I came upon exactly what
    I needed. I most surely will make sure to don?t put out of your mind this web site and
    provides it a look regularly. https://hhydroxychloroquine.com/

    Reply

Leave a Comment