formula in cells

  • Thread starter Thread starter §
  • Start date Start date
§

§

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.
 
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
 
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.
 
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
 
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
 
Back
Top