ROUND to nearest 500 or 1000?

Does this exist in appsheets math formulas?

1 Like

Try this:

500*ROUND([Column Reference]/500)

Basically, we’re just normalising it all to the factor of 500 (think of how we divide numbers to get percents).
(1) Divide the number by 500. This tells you how many 500’s you have.
(2) Round that to the nearest integer because that represents the numbers in between.
(3) Multiply by 500. You now know how many 500’s you’ve got, so multiply that back in and you’ve got your answer.

EXAMPLES:
Rounding Down (using 600 as the starting number)
(1) 600/500 = 1.2. The 0.2 represents the 100 you’re trying to round out.
(2) ROUND(1.2) = 1. Rounds to nearest integer, so you’ve got 1 500 to care about.
(3) 1*500 = 500. Yay!!

Rounding Up (using 800 as the starting number)
(1) 800/500 = 1.6. The 0.6 represents the 100’s you’re trying to round out.
(2) ROUND(1.6) = 2. Rounds to nearest integer, so you’ve got 2 500’s to care about.
(3) 2*500 = 1000. Yay!!

Does that work for you?

2 Likes

Divide by 500.0, not 500. Details here:

1 Like

Ooh. Is this basically significant figures for AppSheet?! If so, that’s awesome!! Tucking that in my back pocket for reporting for sure.