![]() |
Help with setting a formula
I am attempting to setup two columns. One column is adding charges. The
other is showing the charges deducted from a starting balance. I am trying to keep track of a cash card as I am spending the funds. -- Thanks in advance for your assistance HankL |
Help with setting a formula
Put your initial balance in A1 and nothing in B1
In A2 enter: =A1-B2 and copy down As you enter charges in B2 and going down, they will be debitted in column A and the balance will appear. -- Gary''s Student - gsnu200791 "HankL" wrote: I am attempting to setup two columns. One column is adding charges. The other is showing the charges deducted from a starting balance. I am trying to keep track of a cash card as I am spending the funds. -- Thanks in advance for your assistance HankL |
All times are GMT +1. The time now is 06:02 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com