formula

  • Thread starter Thread starter gabbycab
  • Start date Start date
G

gabbycab

calculte the balance into h5 so that it can be copied to cells H6 to
H12. for any row, the balance is the balance from the previous row plus
ant amounts paid-in anf less any payments for stationary, postage and
sudries. In h4 there is a balance of $32.00 do i add paid-ins to this
than minus the pay outs? hope you can help me with this thank you for
any help i can get with this problem. :)
 
Sounds good...

H5 should look sort of like

=h4+<an_income>+<an_income>-<an_expense>-<an_expense>

Once you have done this, copy the formula down to H12. You should find Excel
will very intelligently adapt the formula relative for each row.
 
Sounds good...

H5 should look sort of like

=h4+<an_income>+<an_income>-<an_expense>-<an_expense>

Once you have done this, copy the formula down to H12. You should find Excel
will very intelligently adapt the formula relative for each row.
 
Sounds good...

H5 should look sort of like

=h4+<an_income>+<an_income>-<an_expense>-<an_expense>

Once you have done this, copy the formula down to H12. You should find Excel
will very intelligently adapt the formula relative for each row.
 
Back
Top