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
Bookmarks