Reacuring subtraction from a balance

P

Peter

Hi

I am trying to get a formula for this.

box 1 has the original value say £18.00
box 2 is the payment say £1.00
box 3 is the new ballance. say £17.00 then i want to use this balance to
take another payment from box 2 say £1.00 then box 3 becomes say £16.00

can this be doen or am i asking to much of Excel?

any help would be much appreciated....

Peter
 
A

Atishoo

I guess the question is at what point do you want it to stop calculating?
when a cell value = 0 ?
 

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