LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Bentley
 
Posts: n/a
Default 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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem with combining cells yhm Excel Discussion (Misc queries) 1 June 2nd 05 12:33 PM
Delete - Shift Cells UP problem Ralph Excel Discussion (Misc queries) 3 March 22nd 05 11:19 PM
Adding contents of cells by clicking in Excel 2002 Kevin Gordon Excel Discussion (Misc queries) 7 January 11th 05 04:49 PM
Adding formatted cells to an outline ? Glenn Excel Discussion (Misc queries) 4 January 11th 05 04:10 PM
ADDING SUM TOTAL OF MORE THAN 30 CELLS IN A COLUMN TOGETHER - WON. Robin Smith Excel Discussion (Misc queries) 0 December 20th 04 08:47 PM


All times are GMT +1. The time now is 10:10 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"