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?

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?

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?

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?