| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Adding numbers in a column that have 3 decimal places
Hi
I have the following numbers in H8:H13: 1.000 1.000 0.088 0.751 0.252 1.000 When I add these up in cell H7, using =Sum(H8:H13), the answer is 4.090. It should be 4.091 Why is this happening....and how can I stop it from doing that or how can I adjust my formula to make it add these numbers correctly? Thanks in advance for your help!! Kimberly :) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In MS Excel, how do I change the column ref headers from numbers . | Excel Discussion (Misc queries) | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
| up to 7 functions? | Excel Worksheet Functions | |||
| Average of numbers in column between to other numbers | Excel Discussion (Misc queries) | |||
| I NEED TO SUM NUMBERS ON A COLUMN THAT HAVE TEXT AND NUMBERS | Excel Worksheet Functions | |||
Threaded Mode
