Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Balances
Ok, suppose my sheet looks like the following:
A B C Debit Credit Balance 100 100 300 400 50 350 I just typed those values in but I would like to have Column "C" compute that if the amount is column "A" then add to get the balance in column "C"; and subtract if the amount is in column "B" . I would like for this formula to be able to go all the way down column C. ANYONE???? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Balances
In C2, use the formula =C1+A2-B2, and copy down.
-- David Biddulph "GA85" wrote in message ... Ok, suppose my sheet looks like the following: A B C Debit Credit Balance 100 100 300 400 50 350 I just typed those values in but I would like to have Column "C" compute that if the amount is column "A" then add to get the balance in column "C"; and subtract if the amount is in column "B" . I would like for this formula to be able to go all the way down column C. ANYONE???? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Balances
your first formula in the column c will be =a1-b1
and your second formula in column c is =$C1+A2-B2 then drag the formula down as many rows as you need. Hope this helps. "GA85" wrote: Ok, suppose my sheet looks like the following: A B C Debit Credit Balance 100 100 300 400 50 350 I just typed those values in but I would like to have Column "C" compute that if the amount is column "A" then add to get the balance in column "C"; and subtract if the amount is in column "B" . I would like for this formula to be able to go all the way down column C. ANYONE???? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Balances
I know it needs to include some type of relative or absolute reference...
"David Biddulph" wrote: In C2, use the formula =C1+A2-B2, and copy down. -- David Biddulph "GA85" wrote in message ... Ok, suppose my sheet looks like the following: A B C Debit Credit Balance 100 100 300 400 50 350 I just typed those values in but I would like to have Column "C" compute that if the amount is column "A" then add to get the balance in column "C"; and subtract if the amount is in column "B" . I would like for this formula to be able to go all the way down column C. ANYONE???? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Balances
It does include relative references. It is a typical balance formula
where you refer to the cell above as well -- Regards, Peo Sjoblom "GA85" wrote in message ... I know it needs to include some type of relative or absolute reference... "David Biddulph" wrote: In C2, use the formula =C1+A2-B2, and copy down. -- David Biddulph "GA85" wrote in message ... Ok, suppose my sheet looks like the following: A B C Debit Credit Balance 100 100 300 400 50 350 I just typed those values in but I would like to have Column "C" compute that if the amount is column "A" then add to get the balance in column "C"; and subtract if the amount is in column "B" . I would like for this formula to be able to go all the way down column C. ANYONE???? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Balances
The below would accomplish what you initially requested. Since there is no $
in the formula, the references are relative, but that needn't be the case. Is there a more complex request hidden within this that may require futher difficulty? "GA85" wrote: I know it needs to include some type of relative or absolute reference... "David Biddulph" wrote: In C2, use the formula =C1+A2-B2, and copy down. -- David Biddulph "GA85" wrote in message ... Ok, suppose my sheet looks like the following: A B C Debit Credit Balance 100 100 300 400 50 350 I just typed those values in but I would like to have Column "C" compute that if the amount is column "A" then add to get the balance in column "C"; and subtract if the amount is in column "B" . I would like for this formula to be able to go all the way down column C. ANYONE???? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Balances
One additional question on this.
This makes the balance visable down the entire Balance column. How do you make this display a balance only when there are entries in Columns B and C? Yet still keep the running total correct? Like this: Opening balance: 1000.00 A B C D Item Depit Credit Bal ------------------------------- Entry1 100 1100.00 Entry2 150 950.00 Entry3 Entry4 200 1150.00 (nothing displayed here on down...) Thanks, John "Peo Sjoblom" wrote: It does include relative references. It is a typical balance formula where you refer to the cell above as well -- Regards, Peo Sjoblom "GA85" wrote in message ... I know it needs to include some type of relative or absolute reference... "David Biddulph" wrote: In C2, use the formula =C1+A2-B2, and copy down. -- David Biddulph "GA85" wrote in message ... Ok, suppose my sheet looks like the following: A B C Debit Credit Balance 100 100 300 400 50 350 I just typed those values in but I would like to have Column "C" compute that if the amount is column "A" then add to get the balance in column "C"; and subtract if the amount is in column "B" . I would like for this formula to be able to go all the way down column C. ANYONE???? |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Balances
=IF(COUNT(B2,C2)=1,D1+B2-C2,"")
-- David Biddulph "DocBrown" wrote in message ... One additional question on this. This makes the balance visable down the entire Balance column. How do you make this display a balance only when there are entries in Columns B and C? Yet still keep the running total correct? Like this: Opening balance: 1000.00 A B C D Item Depit Credit Bal ------------------------------- Entry1 100 1100.00 Entry2 150 950.00 Entry3 Entry4 200 1150.00 (nothing displayed here on down...) Thanks, John "Peo Sjoblom" wrote: It does include relative references. It is a typical balance formula where you refer to the cell above as well -- Regards, Peo Sjoblom "GA85" wrote in message ... I know it needs to include some type of relative or absolute reference... "David Biddulph" wrote: In C2, use the formula =C1+A2-B2, and copy down. -- David Biddulph "GA85" wrote in message ... Ok, suppose my sheet looks like the following: A B C Debit Credit Balance 100 100 300 400 50 350 I just typed those values in but I would like to have Column "C" compute that if the amount is column "A" then add to get the balance in column "C"; and subtract if the amount is in column "B" . I would like for this formula to be able to go all the way down column C. ANYONE???? |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Balances
I'm not sure this works.
Let's say that C and D in row 'Entry3' has no values, then the 'if' is false, and no value is placed in the D column. But now Row 'Entry4' has no value to use in the calulation and the error #VALUE! occurs. Am I missing something? "David Biddulph" wrote: =IF(COUNT(B2,C2)=1,D1+B2-C2,"") -- David Biddulph "DocBrown" wrote in message ... One additional question on this. This makes the balance visable down the entire Balance column. How do you make this display a balance only when there are entries in Columns B and C? Yet still keep the running total correct? Like this: Opening balance: 1000.00 A B C D Item Depit Credit Bal ------------------------------- Entry1 100 1100.00 Entry2 150 950.00 Entry3 Entry4 200 1150.00 (nothing displayed here on down...) Thanks, John "Peo Sjoblom" wrote: It does include relative references. It is a typical balance formula where you refer to the cell above as well -- Regards, Peo Sjoblom "GA85" wrote in message ... I know it needs to include some type of relative or absolute reference... "David Biddulph" wrote: In C2, use the formula =C1+A2-B2, and copy down. -- David Biddulph "GA85" wrote in message ... Ok, suppose my sheet looks like the following: A B C Debit Credit Balance 100 100 300 400 50 350 I just typed those values in but I would like to have Column "C" compute that if the amount is column "A" then add to get the balance in column "C"; and subtract if the amount is in column "B" . I would like for this formula to be able to go all the way down column C. ANYONE???? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum Individual Account Balances | Excel Discussion (Misc queries) | |||
Running Balances | Excel Discussion (Misc queries) | |||
running balances | Excel Discussion (Misc queries) | |||
Showing zero balances | Excel Discussion (Misc queries) | |||
How to link endings balances to beginning balances on different sh | Excel Worksheet Functions |