Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum Function
Hi,
I have a spreadsheet invoice were most of the line charges are formulas looking up other spreadsheets. There is a sum function for the total of the column, however when it adds: $326.08 and $32.61 the total given is $358.61. It should be $385.69. All the cells that are being added have been formated to 2 decinal places. How do i get the correct answer? -- Nenagh |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum Function
The cells to be added need not only be formatted to 2 decimal places, they
also have to be rounded (see for ROUND function), so that that Excel calculates values exactly as they are being displayed. Joerg "Nenagh" wrote in message ... Hi, I have a spreadsheet invoice were most of the line charges are formulas looking up other spreadsheets. There is a sum function for the total of the column, however when it adds: $326.08 and $32.61 the total given is $358.61. It should be $385.69. All the cells that are being added have been formated to 2 decinal places. How do i get the correct answer? -- Nenagh |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum Function
If you can't or don't want to apply the ROUND function to the values used
for the summation, you can use ROUND in your SUM function. Example: A1: 326.084 (displays as 326.08) A2: 32.614 (displays as 32.61) A3: =SUM(A1:A2) (displays as 358.70 <= you want this to be displayed as 358.69) You could use an array formula in A3 to get the desired result: =SUM(ROUND(A1:A2,2)) You need to input the formula with Ctrl+Shift+Enter, not just Enter. This will put curly brackets around the formula. Cheers, Joerg "Joerg Mochikun" wrote in message ... The cells to be added need not only be formatted to 2 decimal places, they also have to be rounded (see for ROUND function), so that that Excel calculates values exactly as they are being displayed. Joerg "Nenagh" wrote in message ... Hi, I have a spreadsheet invoice were most of the line charges are formulas looking up other spreadsheets. There is a sum function for the total of the column, however when it adds: $326.08 and $32.61 the total given is $358.61. It should be $385.69. All the cells that are being added have been formated to 2 decinal places. How do i get the correct answer? -- Nenagh |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions |