Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
My formula gives a wrong total...help! | Excel Discussion (Misc queries) | |||
addition total is wrong | Excel Worksheet Functions | |||
Sum Wrong total but add each cell gives the correct total | Excel Worksheet Functions | |||
Formula total wrong | Excel Worksheet Functions | |||
Sum Function with wrong total shown | Excel Worksheet Functions |