Round Of to Nearest 5

[Amit_Jain1]

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

[Steve]

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.

1. ([number] / 5) gives the number of whole 5s in [number].

2. (... * 5) gives the closest multiple of 5 below [number].

3. MOD([number], 5) gives the amount in [number] that isn’t a multiple of 5.

4. (... / 5.0) computes the percentage (between 0.0 and 1.0) of 5 the value from (3) represents.

5. ROUND(...) rounds the percentage from (4) to either 0 or 1.

6. (... * 5) converts the rounded 0 or 1 from (5) to 0 or 5.

7. (... + ...) adds the rounded 0 or 5 from (6) to the closest multiple of 5 below [number] from (2).

[Amit_Jain1]

No Success

[Aleksi · Accepted solution]

ROUND([number]/5)*5 should work.

[Amit_Jain1]

Thanks Both of You
Later one Worked