On Rounding Numbers

You can replace any one of these formulas with the following functions.

• round() - round number

• ceil() - round number to highest return

• floor() - round number to lowest return

Nearest HUNDREDTH

• Convert 77.019 → 77.02

• Convert 77.254 → 77.25

• Convert 77.519 → 77.52

• Convert 77.754 → 77.75

round(100 * prop("Number")) / 100

Nearest Tenth

• Convert 77.01 → 77.

• Convert 77.25 → 77.3

• Convert 77.51 → 77.5

• Convert 77.75 → 77.8

round(10 *prop("Number")) / 10

Nearest Midpoint (.5)

• Convert 77.01 → 77

• Convert 77.25 → 77.5

• Convert 77.51 → 77.5

• Convert 77.75 → 78

round(prop("Number") / .5) * .5

Nearest Whole Number

• Convert 77.01 → 77

• Convert 77.25 → 77

• Convert 77.51 → 78

• Convert 77.75 → 78

round(prop("Number"))

Nearest Multiple Of 5

• Convert 72 → 70

• Convert 73 → 75

• Convert 78 → 80

round(prop("Number") / 5) * 5

Nearest Multiple Of 10

• Convert 74 → 70

• Convert 75 → 80

round(prop("Number") / 10) * 10

Nearest Multiple Of 25

• Convert 12 → 0

• Convert 13 → 25

• Convert 38 → 50

• Convert 63 → 75

• Convert 88 → 100

round(prop("Number") / 25) * 25

View Example In Notion