Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
cells adding problem
When I add two numbers from two cells (=b9 + c9) the answer in d9 is one cent
too much. If I add the exact numbers instead of the cell reference, then the result is correct (b9= 47,334.89; c9= -33,113.61 and correct answer is 14,221.28). What is adding the extra penny to give me 14,221.29? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
cells adding problem
http://www.mcgimpsey.com/excel/pennyoff.html
-- Kind regards, Niek Otten "Bentley" wrote in message ... When I add two numbers from two cells (=b9 + c9) the answer in d9 is one cent too much. If I add the exact numbers instead of the cell reference, then the result is correct (b9= 47,334.89; c9= -33,113.61 and correct answer is 14,221.28). What is adding the extra penny to give me 14,221.29? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
cells adding problem
I'll bet that there are formulas in B9 and C9, and you have those cells
*formatted* to 2 decimal places! Don't forget, formatting only changes the display of the value, *not* the actual value, so I would guess that the *actual* values in those 2 cells are not exactly what's displayed. You may want to *round* your formulas, so that WYSIWYG. =ROUND("your formula",2) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Bentley" wrote in message ... When I add two numbers from two cells (=b9 + c9) the answer in d9 is one cent too much. If I add the exact numbers instead of the cell reference, then the result is correct (b9= 47,334.89; c9= -33,113.61 and correct answer is 14,221.28). What is adding the extra penny to give me 14,221.29? |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
cells adding problem
Select each of B9 and C9 in turn and look in Formula bar.
Are they formulas or values? I expect these cells are formatted to display 2 decimal values but actually hold values with more Example 2.334 and 3.334 would add to 5.67 but you are seeing 2.33 + 3.33 = 5.67 Solution? Depends on your needs. If B9 and C9 have formulas change the to ROUND(formula,2) OR in D9 use =ROUND(B9,2)+ROUND(C9,2) Happy New Year -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Bentley" wrote in message ... When I add two numbers from two cells (=b9 + c9) the answer in d9 is one cent too much. If I add the exact numbers instead of the cell reference, then the result is correct (b9= 47,334.89; c9= -33,113.61 and correct answer is 14,221.28). What is adding the extra penny to give me 14,221.29? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with combining cells | Excel Discussion (Misc queries) | |||
Delete - Shift Cells UP problem | Excel Discussion (Misc queries) | |||
Adding contents of cells by clicking in Excel 2002 | Excel Discussion (Misc queries) | |||
Adding formatted cells to an outline ? | Excel Discussion (Misc queries) | |||
ADDING SUM TOTAL OF MORE THAN 30 CELLS IN A COLUMN TOGETHER - WON. | Excel Discussion (Misc queries) |