ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Help with setting a formula (https://www.excelbanter.com/new-users-excel/191245-help-setting-formula.html)

HankL

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

Gary''s Student

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