🧲

Round Numbers (.01 ... .5 ... 1 ... 5 ... 25)

Master Tag
Tips & Tricks
Created
Sep 28, 2020 04:04 PM
Usage
Round
Web Tags
Formula
Database
Cover
Round to the nearest ...
Name
Number
Nearest .01
Nearest .1
Nearest .5
Nearest 1
Nearest 5
Nearest 10
Nearest 25
77.019
77.254
77.519
77.754

Round To Nearest .01

  • 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

Round To Nearest .1

  • Convert 77.01 β†’ 77.
  • Convert 77.25 β†’ 77.3
  • Convert 77.51 β†’ 77.5
  • Convert 77.75 β†’ 77.8
round(10 *prop("Number")) / 10

Round To Nearest .5

  • Convert 77.01 β†’ 77
  • Convert 77.25 β†’ 77.5
  • Convert 77.51 β†’ 77.5
  • Convert 77.75 β†’ 78
round(prop("Number") / .5) * .5

Round To Nearest 1

  • Convert 77.01 β†’ 77
  • Convert 77.25 β†’ 77
  • Convert 77.51 β†’ 78
  • Convert 77.75 β†’ 78
round(prop("Number"))

Round To Nearest 5

  • Convert 72 β†’ 70
  • Convert 73 β†’ 75
  • Convert 78 β†’ 80
round(prop("Number") / 5) * 5

Round To Nearest 10

  • Convert 74 β†’ 70
  • Convert 75 β†’ 80
round(prop("Number") / 10) * 10

Round To Nearest 25

  • Convert 12 β†’ 0
  • Convert 13 β†’ 25
  • Convert 38 β†’ 50
  • Convert 63 β†’ 75
  • Convert 88 β†’ 100
round(prop("Number") / 25) * 25
Β