Check out Travel Photography - Tips and More section of our forum.
Weird Excel experience
May 2, 2024 10:18:13 #
RustyM wrote:
The problem may be the use of the sum function. Normally, it would reference a range, not a formula. Try using just the formula =b2+c3.
That is my thinking too.
May 2, 2024 11:17:54 #
Another option - you can download a free checkbook register in various formats (Excel, Google Sheets, Open Office Calc) from ExcelDataPro
Looks like this:
Looks like this:
May 2, 2024 11:19:17 #
Shellback wrote:
Another option - you can download a free checkbook register in various formats (Excel, Google Sheets, Open Office Calc) from ExcelDataPro
Looks like this:
Looks like this:
Well, that may eliminate the problem without ever finding out what the problem was.....
Check out Black and White Photography section of our forum.
May 2, 2024 11:23:35 #
May 2, 2024 11:27:59 #
Longshadow wrote:
Well, that may eliminate the problem without ever finding out what the problem was.....
Yep - the old ‘work smarter not harder’ concept
May 2, 2024 11:47:34 #
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.
May 2, 2024 11:57:50 #
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 out Traditional Street and Architectural Photography section of our forum.
May 2, 2024 13:44:41 #
SteveR wrote:
I have sent the file to Longshadow. Hopefully he can figure out what's going on. It HAS been awhile since I used Excel extensively and then I had good manuals. Between it and DbaseIV I had a couple of powerful tools. BUT, it's been awhile.
Good plan.
May 2, 2024 18:48:22 #
May 3, 2024 02:17:05 #
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.
May 3, 2024 10:13:13 #
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.
May 3, 2024 10:15:25 #
Shellback wrote:
Another option - you can download a free checkbook register in various formats (Excel, Google Sheets, Open Office Calc) from ExcelDataPro
Looks like this:
Looks like this:
Can columns in this be deleted if not needed? It looks promising.
May 3, 2024 10:16:42 #
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.
May 3, 2024 11:01:08 #
StanMac
Loc: Tennessee
Clear the cells in question then paint the formatting from cells that are working properly.
Stan
Stan
May 3, 2024 13:07:31 #
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.
Check out Drone Video and Photography Forum section of our forum.