Forum Discussion
Solved
How to ROUND like this?
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
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 )
)