LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
stat721
 
Posts: n/a
Default Error in Addition and Subtraction

Whomever can help,

I have created a spreadsheet that links balances from day to day. All of
these balances are used in formulas. The problem I am having is when one
specific number is subtracted from another number I am getting an incorrect
answer. For example, I am taking (these are not the actual numbers)
200,000(hardcoded) - 200,000 (referenced to another sheet) and getting
-.0000000023283064365387. It did this on one day when all of the other days
are right. Note: all current day balances are hard coded, only two numbers
are referenced to the day before, and NONE of the numbers have more than two
numbers behind the decimal. So how is this answer possible? One thing i
have done is hard-code the referenced number and I got the right answer. So
I am thinking it has to do with the referenced number, but none of the
referenced numbers have more than two numbers behind the decimal. Please
help! Thanks.

-J
 
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



All times are GMT +1. The time now is 03:24 PM.

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

About Us

"It's about Microsoft Excel"