Formula question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Here's what I'm trying to do: G6 is the dollar amount paid; I6 is the
previous balance; and K6 is the current balance. Currently I have
=SUM(I6,-G6) in K6 to give me a running balance. Once I change the amount in
G6, K6 is updated with a new balance. Is there a formula I can enter in I6
that will change the total to the number in K6 before K6 changes? Thank you.
 
In I7, you could enter the formula: =K6
Here's what I'm trying to do: G6 is the dollar amount paid; I6 is the
previous balance; and K6 is the current balance. Currently I have
=SUM(I6,-G6) in K6 to give me a running balance. Once I change the amount in
G6, K6 is updated with a new balance. Is there a formula I can enter in I6
that will change the total to the number in K6 before K6 changes? Thank you.
Click to expand...
 

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

IF Statements 1
Using the COUNTA function 1
VLOOKUP 4
problem with formulas (2) 7
Change cell colour 2
Is there an Excel Function that can be used in lieu of this formul 5
Filter Multiple Criteria - Show me the MONEY! 1
Last "non-blank" value in a Row... 2

Back
Top