Please Help for Macro or Formula

K

K

Hi, Please see the Excel file by clicking on or by typing in internet
address bar the link below. I need a Macro or Formula to calculate
specific balance. Every thing been explained on the Excel sheet.
Please if anybody can help
Thanks.

Link to file:-


http://www.savefile.com/files/1350632
 
M

Mike Fogleman

Bob's formula is correct to get you started in cell F3. In order to keep a
running balance in column F, put this formula in F4 and copy it down to F11
(or wherever):

=IF(A4<>"",F3,F3-IF(E4=0,C4,E4))

Mike F
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top