C
Carolan
I have a column of figures which is the result of multiplied column A x
Column B. Column B is a multiplier of .001665. The result is shown to two
decimal places. When I total the results in Column B, using formula
=SUM(B1:B2), it gives the result as 11.16 instead of 11.15. Can I fix this
somehow so it gives the correct total?
Example
A Formula in B Result in B
3250.00 =A1x0.001665 5.41
3450.00 =A2x0.001665 5.74
Total 11.16
Column B. Column B is a multiplier of .001665. The result is shown to two
decimal places. When I total the results in Column B, using formula
=SUM(B1:B2), it gives the result as 11.16 instead of 11.15. Can I fix this
somehow so it gives the correct total?
Example
A Formula in B Result in B
3250.00 =A1x0.001665 5.41
3450.00 =A2x0.001665 5.74
Total 11.16