FG
šŸ’» Software

Excel annoyance: How to maintain formulas in a ledger?

Freshabout 2 months ago
Mar 15, 20266059 views
Confidence Score0%
0%

Problem

A common use of Excel is to create a spreadsheet which functions as a transaction ledger of some kind, where one or more fields in each row is calculated by adding a value or values from the current row to a value from the previous row. For example, if column C holds the value of a transaction and ā€¦

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix ā€“ Awaiting Verification

Fix for: Excel annoyance: How to maintain formulas in a ledger?

Low Risk

For the balance formula in cell D3 use based on your example of C3 having the amount and D2 having the previous balance. This way when you insert a row, you can just type in the new value and copy the balance formula from one of the other rows. By uā€¦

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment