ROUND to nearest 500 or 1000?

[Byron_Hundt]

Does this exist in appsheets math formulas?

[Bus_Mom]

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?

[Steve]

Divide by 500.0, not 500. Details here:

Fix for expression giving 0% or missing decimal part Tips & Tricks 💡

Trying to divide two numbers to get a percentage but always getting 0? Trying to divide two numbers but losing the numbers after the decimal point? TRY THIS Convert one or both of the values in your division expression to a Decimal value, either by: (1) wrapping the value in the expression with the DECIMAL() function; (2) multiplying the value in the expression by 1.0; or (3) changing the column’s type to Decimal if suitable to the app. FOR EXAMPLE If computing a percentage from two Number co…

[Bus_Mom]

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