I want Formula to Round To Nearest 5
[Abc Column] = 16
Formula in [XYZ Column] Sugessition Value
List(0+ROUND ([Abc Column] *50.8))
Result is 813
I want Result to Show 815
Is There any Way to Achieve this Result
Solved! Go to Solution.
ROUND([number]/5)*5 should work.
Hereโs my idea:
((([number] / 5) * 5) + (ROUND(MOD([number], 5) / 5.0) * 5))
I wouldnโt be surprised if thereโs a better way to do it.
([number] / 5)
gives the number of whole 5s in [number]
.
(... * 5)
gives the closest multiple of 5 below [number]
.
MOD([number], 5)
gives the amount in [number]
that isnโt a multiple of 5.
(... / 5.0)
computes the percentage (between 0.0 and 1.0) of 5 the value from (3) represents.
ROUND(...)
rounds the percentage from (4) to either 0 or 1.
(... * 5)
converts the rounded 0 or 1 from (5) to 0 or 5.
(... + ...)
adds the rounded 0 or 5 from (6) to the closest multiple of 5 below [number]
from (2).
No Success
ROUND([number]/5)*5 should work.
Thanks Both of You
Later one Worked
User | Count |
---|---|
39 | |
32 | |
30 | |
16 | |
14 |