"He that would make his own liberty secure, must guard even his enemy from oppression; for if he violates this duty, he establishes a precedent that will reach to himself."
Been scratching my head for 15 minutes on this and still don't know what the hell is going on.
Both tables are the same with one exception - the way the Payment Amount for June 2017 is entered. In the table on the left, the 6.28 in cell L26 is typed, not a formula. In the table on the right, the 6.28 in cell P26 is a formua (=R25). All values in the Payment Amount and Credit columns in both tables are typed in exactly the same.
The Ending Balances for both tables should be 0...not a number close to 0, but exactly 0. And yet, they're not. The table on the left is returning a number in scientific notation that is very close to zero. I included a sum of the Payment Amounts and Credits to show that they are indeed exactly 500 for both tables, so mathematically, the value in L26 is incorrect. So why is Excel doing this?
Mon Jun 19, 2017 10:13 am
danoh
Site Supporter
Location: Sumner, WA Joined: Mon Oct 15, 2012 Posts: 3026
Real Name: Dan
Been scratching my head for 15 minutes on this and still don't know what the hell is going on.
Both tables are the same with one exception - the way the Payment Amount for June 2017 is entered. In the table on the left, the 6.28 in cell L26 is typed, not a formula. In the table on the right, the 6.28 in cell P26 is a formua (=R25). All values in the Payment Amount and Credit columns in both tables are typed in exactly the same.
The Ending Balances for both tables should be 0...not a number close to 0, but exactly 0. And yet, they're not. The table on the left is returning a number in scientific notation that is very close to zero. I included a sum of the Payment Amounts and Credits to show that they are indeed exactly 500 for both tables, so mathematically, the value in L26 is incorrect. So why is Excel doing this?
Well, since P26=R25, then your ending balance will always be exactly zero in the right hand column.
In the left hand column, I can only surmise that L25 is not EXACTLY 6.28000000000 . . . but rather is just a hair higher than 6.28, but Excel is rounding it off.
I'm going to guess that the cell L26 (or wherever you typed in the value rather than the formula) is not formatted as a number.
_________________ “Finding ‘common ground’ with the thinking of evil men is a fool’s errand” ~ Herschel Smith
"The said Constitution shall never be construed to authorize Congress to prevent the people of the United States who are peaceable citizens from keeping their own arms." ~ Samuel Adams
“A return to First Principles in a Republic is sometimes caused by simple virtues of a single man. His good example has such an influence that the good men strive to imitate him, and the wicked are ashamed to lead a life so contrary to his example. Before all else, be armed!” ~ Niccolo Machiavelli
Users browsing this forum: MPDCLTRET and 62 guests
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot post attachments in this forum