Subtracting From 2 Cells

  • Thread starter Thread starter scw1217
  • Start date Start date
S

scw1217

I need to have a running difference between amounts from 2 differen
cells. For instance, in cell A1 I have 10,000 and in A2 I have 5,000.
However, in cells B1, B2, etc. I have varying amounts. I need a cell
such as A3 to keep a running subtraction from A1 until it reaches zer
(0) and then to switch over to A2 and subtract from the 5,000. Ca
this be done
 
Let's say you're subtracting the values in cells B1:B100. Use this formula
in A3

=A1-sum(B1:b100)+A2*(sum(B1:b100)>A1)
 
You must log in or register to reply here.

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

How to subtract a number from a Mergefield? 0
I need to add multiple cells then subtract them from one cell c4+c6+c7+c9+c10+c11 and subtract them 1
Error in subtracting times 2
subtract one cell from each cell in a range and count instances 2
subtract a single cell from range of cells and then count 8
subtract 2 cells and get blank instead of 0.0 3
Formula Subtracting Business Days 3
need to subtract one cell from each cell in a row 1

Back
Top