formula in cells

§

§

I'm going to try and explain this a little better and give you the actual
cells that I am trying to calculate:

I have net pay in cell B8,
withdraws in cell C8 and
the Balance in D8.

I would like row D to add B, subtract C and display the balance.
So when I put in the next paycheck on B9, D9 will reflect the amount from
D8, add to it B9, subtract C9 if a value is there and display the balance in
D9. I would like the cells in Column D for the last value entered to be
blank until data is entered into them and not display the last balance the
whole way down the spread sheet. Does this make better sense? And can it
be done?

Thanks for all the help.
 
O

Otto Moehrbach

One way:
Put this formula in D8 and drag down as far as you want. It will display a
running total and will display a blank cell if B & C are both blank.
=IF(AND(B8="",C8=""),"",D7+B8-C8)

HTH Otto
 
R

RagDyeR

One way:

=IF(AND(B8="",C8=""),"",SUM($B$8:B8)-SUM($C$8:C8))
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


I'm going to try and explain this a little better and give you the actual
cells that I am trying to calculate:

I have net pay in cell B8,
withdraws in cell C8 and
the Balance in D8.

I would like row D to add B, subtract C and display the balance.
So when I put in the next paycheck on B9, D9 will reflect the amount from
D8, add to it B9, subtract C9 if a value is there and display the balance in
D9. I would like the cells in Column D for the last value entered to be
blank until data is entered into them and not display the last balance the
whole way down the spread sheet. Does this make better sense? And can it
be done?

Thanks for all the help.
 
R

RagDyeR

Might be a problem Otto, if D7 has a header label.
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

One way:
Put this formula in D8 and drag down as far as you want. It will display a
running total and will display a blank cell if B & C are both blank.
=IF(AND(B8="",C8=""),"",D7+B8-C8)

HTH Otto
 
R

RagDyeR

This would work though:

=IF(AND(B8="",C8=""),"",SUM(D7,B8-C8))
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------


Might be a problem Otto, if D7 has a header label.
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

One way:
Put this formula in D8 and drag down as far as you want. It will display a
running total and will display a blank cell if B & C are both blank.
=IF(AND(B8="",C8=""),"",D7+B8-C8)

HTH Otto
 

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

Similar Threads

Summing a range of cells based on criteria in another range 2
#value error 3
COUNTIF Formula - Bug? 5
Re : Excel Data>Sort... Tracking of Cell Addresses Used in Formulae 1
I need to add multiple cells then subtract them from one cell c4+c6+c7+c9+c10+c11 and subtract them 1
How do I keep the divisor constant in calculating percentage remai 3
Countif() formula 3
Copy/Paste Formula-dropping 1st cell address 1

Top