I’m trying to figure out how to round the results of simple math to the nearest 5.

How can I round 192 down to 190 and 193 up to 195 for the result? I can’t seem to find anything that will do this.

Thanks in advance

I’m trying to figure out how to round the results of simple math to the nearest 5.

How can I round 192 down to 190 and 193 up to 195 for the result? I can’t seem to find anything that will do this.

Thanks in advance

To round a number to the nearest 5, use the formula:

`ROUND(number/5)*5`

But replace the text “number” with an actual number/variable, etc.

1 Like

Genius! Thank so much