Changes

First thing we can note is that result from method 1 differs of result from method 2. Difference is only 0.01 but if you have n times the same line, difference can be higher but always lower or equal to (n-1)*0.01.

First thing we can note is that result from method 1 differs of result from method 2. Difference is only 0.01 but if you have n times the same line, difference can be higher but always lower or equal to (n-1)*0.01.

Also if you decide to round up or down instead of "to the nearest", you will have same problem (for example with a rounding down, try with a quantity of 2 on line 2 and you will have same differences between method 1 and 2). Difference will just appears with different data but will still occurs.

Also if you decide to round up or down instead of "to the nearest", you will have same problem (for example with a rounding down, try with a quantity of 2 on line 2 and you will have same differences between method 1 and 2). Difference will just appears with different data but will still occurs, so problem is not on how we make rounding but when.

Second thing we can note is that if we use method 2, we must not show the column I, otherwise to total you will show on your invoice (2.73) will not be same that total you get summing total of each line (1.36+1.36=2.72). Showing column H might be better but total will still differs because total is rounded and result of summing column H lines.

Second thing we can note is that if we use method 2, we must not show the column I, otherwise to total you will show on your invoice (2.73) will not be same that total you get summing total of each line (1.36+1.36=2.72). Showing column H might be better but total will still differs because total is rounded and result of summing column H lines.