View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
scw1217
 
Posts: n/a
Default Subtracting From 2 Cells


I need to have a running difference between amounts from 2 different
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 zero
(0) and then to switch over to A2 and subtract from the 5,000. Can
this be done?


--
scw1217
------------------------------------------------------------------------
scw1217's Profile: http://www.excelforum.com/member.php...fo&userid=2814
View this thread: http://www.excelforum.com/showthread...hreadid=529211