How would you round the number 2.33 up to whole number 3 instead of the 2. Power Query's default for 0.33 is to round down and I want to round up.
Also, how would you wrap the ROUND function in a formula when adding the values of two columns.
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Also, how would you wrap the ROUND function in a formula when adding the values of two columns.
Value | RoundUp | Default |
2.33 | 3 | 2 |
2.67 | 3 | 3 |
3.00 | 3 | 3 |
3.33 | 4 | 3 |
3.67 | 4 | 4 |
4.00 | 4 | 4 |
4.33 | 5 | 4 |
4.67 | 5 | 5 |
5.00 | 5 | 5 |
5.33 | 6 | 5 |
5.67 | 6 | 6 |
6.33 | 7 | 6 |
6.67 | 7 | 7 |
7.00 | 7 | 7 |
7.67 | 8 | 8 |
8.00 | 8 | 8 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>