1 | number | decimals | no_thousand_seperator | Result | Formula | |
---|---|---|---|---|---|---|
2 | 3521.478 | 2 | FALSE | 3,521.48 | =FIXED(A2, 2, FALSE) | |
3 | 3521.478 | 1 | TRUE | 3521.5 | =FIXED(A3, 1, TRUE) | |
4 | 3521.478 | 0 | TRUE | 3521 | =FIXED(A4, 0 , TRUE) | |
5 | 3521.478 | 2 | 0 | 3,521.48 | =FIXED(A5, 2, 0) | |
6 | 3521.478 | 2 | 1 | 3521.48 | =FIXED(A6, 2, 1) | |
7 |