Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtracting From 2 Cells
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) "scw1217" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtracting From 2 Cells
Cool! That worked! Thanks. -- scw1217 ------------------------------------------------------------------------ scw1217's Profile: http://www.excelforum.com/member.php...fo&userid=2814 View this thread: http://www.excelforum.com/showthread...hreadid=529211 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What formula is used for subtracting a range of different cells f. | Excel Worksheet Functions | |||
trouble with subtracting cells and adding text... | Excel Discussion (Misc queries) | |||
trouble with subtracting cells and adding text... | Excel Discussion (Misc queries) | |||
Help adding text values | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |