Does this exist in appsheets math formulas?
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.
User | Count |
---|---|
43 | |
32 | |
25 | |
23 | |
14 |