Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Currency sum not correct Excel 2003
Even though all currency values displayed are 2 decimals on my sheet, when I
use the formula function sum or subtotal to show the total of cells, it is displaying a rounded down amount and is 1 cent off because it is adding as if it knows there are actually 3 decimals in one of the cells even though only two are displayed. Can anyone tell me how to correct this? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Currency sum not correct Excel 2003
You could try
=SUM(ROUND(A1:A10,2)) which is an array formula, it should be committed with Ctrl-Shift-Enter, not just Enter. Excel will automatically enclose the formula in braces (curly brackets), do not try to do this manually. When editing the formula, it must again be array-entered. -- HTH Bob Phillips (there's no email, no snail mail, but somewhere should be gmail in my addy) "IL-Exceluser" wrote in message ... Even though all currency values displayed are 2 decimals on my sheet, when I use the formula function sum or subtotal to show the total of cells, it is displaying a rounded down amount and is 1 cent off because it is adding as if it knows there are actually 3 decimals in one of the cells even though only two are displayed. Can anyone tell me how to correct this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 compatibility | Excel Discussion (Misc queries) | |||
Cannot Open Webpage With Excel 2003 | Excel Discussion (Misc queries) | |||
Very slow in opening Excel 97 file in Excel 2003 | Setting up and Configuration of Excel | |||
Data from Excel 2000 Worksheet with external links is not displayed when opened in Excel 2003 | Links and Linking in Excel | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) |