|
Devils Lake, ND | This is in a spreadsheet I've used for years for balancing my checkbook. The "Balance" column doesn't calculate for new numbers added, until I click the box to review the formula. When I click out, it does the math.
D17-B18+C18, D17 is the old balance, B18 is the new debit, and C18 is the new credit. When I add a new number B18 or C18, D18 doesn't recalculate. Not until I click D18 and hit enter. Then it calculates.
I've used this spreadsheet for a long time, and haven't changed any formulas. It's doing this in several worksheets. Same problem.
Any ideas?
Edited by BSchroeder 5/5/2018 21:38
| |
|
Excel formula problem
