 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / December 2005cells 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? http://www.mcgimpsey.com/excel/pennyoff.html  SignatureKind regards, Niek Otten > 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? 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) SignatureHTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- > 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? 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 SignatureBernard V Liengme www.stfx.ca/people/bliengme remove caps from email > 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 to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.