Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculation Problem
All though the formula is correct ( a simple math addition between 2 cells)
..There are a few of these cells in my 2003 XL Spread Sheet that consistently makes a 1 cent error in the addition - that is, it's adds the cell less 1 cent (formatted in currency) How do I fix this? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculation Problem
http://www.mcgimpsey.com/excel/pennyoff.html
-- Kind regards, Niek Otten Microsoft MVP - Excel "djm123" wrote in message ... All though the formula is correct ( a simple math addition between 2 cells) .There are a few of these cells in my 2003 XL Spread Sheet that consistently makes a 1 cent error in the addition - that is, it's adds the cell less 1 cent (formatted in currency) How do I fix this? Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculation Problem
I expect that the two values being added result from formula and you are
getting round off errors. You are seeing one thing (the cell is formatted to display 2 decimal places) but the stored values are slightly different A1 might display 1.54 but the value stored could be 1.544 B1 might display 2.72 but the value stored could be 2.723 You will expect the formula =A1+B1 to return 4.26 (1.54+2.72) But Excel computes 1.544+2.723 to get 4.267 which it displays as 4.27 (a penny out) You could use =ROUND(A1,2)+ROUND(B1,2) You could change your formula from =a_formula to =ROUND(a_formula,2) You could specify your worksheet uses "precision as displayed" - many Excel authors warn against. Have a look at http://mcgimpsey.com/excel/pennyoff.html best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "djm123" wrote in message ... All though the formula is correct ( a simple math addition between 2 cells) .There are a few of these cells in my 2003 XL Spread Sheet that consistently makes a 1 cent error in the addition - that is, it's adds the cell less 1 cent (formatted in currency) How do I fix this? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculation Problem | Excel Worksheet Functions | |||
calculation problem | Excel Worksheet Functions | |||
Calculation problem | Excel Discussion (Misc queries) | |||
Calculation problem - please help | Excel Discussion (Misc queries) | |||
Calculation Problem | Excel Worksheet Functions |