srizki
Well-known Member
- Joined
- Jan 14, 2003
- Messages
- 1,844
- Office Version
- 365
- Platform
- Windows
Hi all,
Every month I do some manual calculations, in which I have to manually round number to two decimals to match the invoice amount, here is an example, the second column rounded to 2 decimals, =round(…,2), that comes up to 320.05 but the actual should be 320.04, therefore I manually adjust the amounts to match the invoice amount.
Is there an easy way of doing this?
<tbody>
</tbody>
Regards,
Every month I do some manual calculations, in which I have to manually round number to two decimals to match the invoice amount, here is an example, the second column rounded to 2 decimals, =round(…,2), that comes up to 320.05 but the actual should be 320.04, therefore I manually adjust the amounts to match the invoice amount.
Is there an easy way of doing this?
10.8199555 | | 10.82 |
18.4957088 | | 18.50 |
9.5174781 | | 9.52 |
8.47837347 | | 8.48 |
29.9121008 | | 29.91 |
33.7986749 | | 33.80 |
29.9121008 | | 29.91 |
10.4897502 | | 10.49 |
30.3520424 | | 30.35 |
8.51195562 | | 8.51 |
29.9121008 | | 29.91 |
8.36794692 | | 8.37 |
30.3520424 | | 30.35 |
0.52941586 | | 0.53 |
9.90074355 | | 9.90 |
8.28971675 | | 8.29 |
30.0682875 | | 30.07 |
2.81809957 | | 2.82 |
9.5174781 | | 9.52 |
320.043972 | | 320.05 |
<tbody>
</tbody>
Regards,