| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum of digits in column not giving correct sum
My column of numbers is not giving the correct total. My formula for the
total is: =ROUND(SUM(A4:A15),2) The numbers I added are 6.30+1.74+1.24 and got an answer of 9.27 (should be 9.28). The numbers I am adding are formulated from another macro not just a number I inserted (it is a formula to calculate the gst out of a number from another column) and this is why I think I am getting a wrong answer but I don't know how to correct it. Help please! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup command not giving the correct result | Excel Worksheet Functions | |||
| vlookup not giving correct output | Excel Discussion (Misc queries) | |||
| vlookup not giving correct output | Excel Discussion (Misc queries) | |||
| Conditional Formatting not giving correct answer... | Excel Worksheet Functions | |||
| Create a total based on multiple conditions is not giving correct. | Excel Worksheet Functions | |||
Threaded Mode
