Round numbers¶
This processor rounds decimals in one or several columns. It can perform round, floor or ceil.
Significant digits control the precision of the number (e.g. 1234.5 with 2 significant digits is 1200), with 0 meaning unbounded (keep all significant digits).
Decimal places is how many number after the decimal point: 1.234 with 1 decimal place is 1.2. 0 means round to integer, -2 means round to hundreds.
Examples¶
| Input | Significant digits | Decimal places | Output |
|---|---|---|---|
| 0.11 | 0 | 0 | 0 |
| 0.11 | 0 | 1 | 0.1 |
| 0.11 | 0 | 3 | 0.110 |
| 0.11 | 1 | 3 | 0.100 |
| 1.1 | 1 | 1 | 1.0 |
| 1.1 | 2 | 1 | 1.1 |
| 1.1 | 2 | 0 | 1 |
| 11 | 0 | 0 | 11 |
| 11 | 1 | 0 | 10 |
| 11 | 1 | 1 | 10.0 |
| 110 | 1 | 0 | 100 |
| 150 | 1 | 0 | 200 |
| 110 | 0 | -2 | 200 |
| 3456 | 1 | 0 | 3000 |
| 3456 | 0 | -2 | 3500 |