Round to the nearest 5

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