| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
AutoSum lost a penny
Hi I am trying to use autosum to add up a colum of figures but it keeps
loosing a penny. for example £551.99 £459.99 £402.49 £344.99 £632.44 £114.99 £52.89 when these totals are added together on a calculator the total is 2559.78 but when I use autosum the total appears as 2559.77. Please can anyone shed any light as to why this may be. I have checked that there are no other characters in the cells or formula. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| My accounting program is a penny off, Why? | Excel Worksheet Functions | |||
| how do i set up autosum as a % | Excel Worksheet Functions | |||
| lost drop down next to autosum | Excel Discussion (Misc queries) | |||
| How do I keep a running total of pounds lost and percentage lost | Excel Discussion (Misc queries) | |||
| In Excel the total is off by a penny. | Excel Worksheet Functions | |||
Threaded Mode
