Shellback
Loc: North of Cheyenne Bottoms Wetlands - Kansas
Another option - you can download a free checkbook register in various formats (Excel, Google Sheets, Open Office Calc) from
ExcelDataProLooks like this:
Shellback wrote:
Another option - you can download a free checkbook register in various formats (Excel, Google Sheets, Open Office Calc) from
ExcelDataProLooks like this:
Well, that may eliminate the problem without ever finding out what the problem was.....
Shellback
Loc: North of Cheyenne Bottoms Wetlands - Kansas
Longshadow wrote:
Well, that may eliminate the problem without ever finding out what the problem was.....
Yep - the old ‘work smarter not harder’ concept
Fredrick
Loc: Former NYC, now San Francisco Bay Area
SteveR wrote:
I used Excel for years at work with no problems. It WAS, however, a fully licensed program. I am beginning to wonder if the programs that are not fully licensed don't work quite as well. I do know that it's not fully functional in other ways, but at least I thought it would add correctly. I guess I should download 365. The Excel version I'm using came with the Office package of Windows as I recall.
If you PM me with your spreadsheet I’ll figure it out for you. I used excel for many years.
Shellback wrote:
Yep - the old ‘work smarter not harder’ concept
Or, the "I can't figure out the problem so I'll ignore it and go someplace else." concept.
Check auto decimal point placement.
Don
SteveR wrote:
I just set up an Excel spread sheet to track a savings account. I have a column for deposits/withdrawals and a column for balance. I tried to do the =sum forumula to automatically calculate the balance, but when I put in a $300 deposit it added it as $3000. This is not the 365 version. Any ideas?
What happens if you change the deposit to $400 (i.e. increase by $100)? Does it change the result to $3,100, or to $4,000?
This should tell you if the error is in the formula, or elsewhere.
47greyfox
Loc: on the edge of the Colorado front range
I would redo the spreadsheet with 3 columns: deposits, withdrawals, and balance. The running balance formula would be “=a-b+c, where “a” and “b” are the change and “c” is the running balance from the previous (row) entry. All entries would be positive numbers. If i wanted to express withdrawals as negative, the formula would be “=a+b+c.” Use of a “SUM” formula wouldn’t be necessary. As for your issue, I’m thinking that it has to be a cockpit error.
Shellback wrote:
Another option - you can download a free checkbook register in various formats (Excel, Google Sheets, Open Office Calc) from
ExcelDataProLooks like this:
Can columns in this be deleted if not needed? It looks promising.
Use a web browser and search “excel show formulas”. You can then look at any formulas that might be hiding on the sheet. Also check to see that your cell formats are not manipulating the actual number you enter.
Clear the cells in question then paint the formatting from cells that are working properly.
Stan
TriX
Loc: Raleigh, NC
banjoboy wrote:
=b2+c3 No “sum”required
Yep. Plus I’d check the formatting on all the cells, especially the cell with the $300 deposit.
If you want to reply, then
register here. Registration is free and your account is created instantly, so you can post right away.