How to ROUND like this?

[ChrisY]

true    round

901     900

2876   3000

2120   2000

2531   3000

8339   8000

3023   3000

14099 10000

I try ROUND,ROUNDUP,ROUNDDOWN,but it can't work for each number

[Zubair_Muhammad]

@ChrisY

You can use this as calculated column

=
VAR Digits =
    LEN ( [true] ) - 1
VAR second_digit =
    VALUE ( MID ( [true], 2, 1 ) ) >= 5
RETURN
    SWITCH (
        TRUE (),
        second_digit, ROUNDUP ( [true], - Digits ),
        ROUNDDOWN ( [true], - Digits )
    )

[Zubair_Muhammad · Accepted solution]

@ChrisY

Works with your sample data 🙂