ROUND to nearest 500 or 1000?

Does this exist in appsheets math formulas?

1 3 13.6K
3 REPLIES 3

Bus_Mom
Participant I

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?

Divide by 500.0, not 500. Details here:

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

Top Labels in this Space