Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Question
Okay, I don't really know how to word this, so I'm sorry if it sounds awkward.
I'm trying to set up Excel so that it can basically be my checkbook registry so that I don't mess up the math. So, I have a column for debits (D), one for credits (E) and one for the running balance (F). Is there a forumla that I can apply to column F that will see what's in D and E for that row, add or subtract what's there, and then apply that to the previous row's F? Or do I just have to do separate forumlas for each row...? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Question
In your very 1st Row you could enter your debits and credits and this formula
in column F: =E2-D2 (assuming your data starts in row two due to headings.) Then in the next cell down in column F put this formula: =F2+E3-D3 Then copy this formula down as needed in column F. It should look at your previous balance (in F) then add the credit and subtract the debit to create a new balance. "dramajuana" wrote: Okay, I don't really know how to word this, so I'm sorry if it sounds awkward. I'm trying to set up Excel so that it can basically be my checkbook registry so that I don't mess up the math. So, I have a column for debits (D), one for credits (E) and one for the running balance (F). Is there a forumla that I can apply to column F that will see what's in D and E for that row, add or subtract what's there, and then apply that to the previous row's F? Or do I just have to do separate forumlas for each row...? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Question
That's actually exactly what I've been doing. I was just wondering if there
was a forumla I could apply to the column so I didn't have to do that for every row. "tim m" wrote: In your very 1st Row you could enter your debits and credits and this formula in column F: =E2-D2 (assuming your data starts in row two due to headings.) Then in the next cell down in column F put this formula: =F2+E3-D3 Then copy this formula down as needed in column F. It should look at your previous balance (in F) then add the credit and subtract the debit to create a new balance. "dramajuana" wrote: Okay, I don't really know how to word this, so I'm sorry if it sounds awkward. I'm trying to set up Excel so that it can basically be my checkbook registry so that I don't mess up the math. So, I have a column for debits (D), one for credits (E) and one for the running balance (F). Is there a forumla that I can apply to column F that will see what's in D and E for that row, add or subtract what's there, and then apply that to the previous row's F? Or do I just have to do separate forumlas for each row...? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Question
Hi Dramajuana,
on F column use: =(if(or(d3=0,d3="")),f2+d3,f2-c3) hth regards from Brazil Marcelo "dramajuana" escreveu: Okay, I don't really know how to word this, so I'm sorry if it sounds awkward. I'm trying to set up Excel so that it can basically be my checkbook registry so that I don't mess up the math. So, I have a column for debits (D), one for credits (E) and one for the running balance (F). Is there a forumla that I can apply to column F that will see what's in D and E for that row, add or subtract what's there, and then apply that to the previous row's F? Or do I just have to do separate forumlas for each row...? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Question
sory my mistake on the formulae
use =if(d30,f2+d3,f2-e3) hth regards from Brazil Marcelo "Marcelo" escreveu: Hi Dramajuana, on F column use: =(if(or(d3=0,d3="")),f2+d3,f2-c3) hth regards from Brazil Marcelo "dramajuana" escreveu: Okay, I don't really know how to word this, so I'm sorry if it sounds awkward. I'm trying to set up Excel so that it can basically be my checkbook registry so that I don't mess up the math. So, I have a column for debits (D), one for credits (E) and one for the running balance (F). Is there a forumla that I can apply to column F that will see what's in D and E for that row, add or subtract what's there, and then apply that to the previous row's F? Or do I just have to do separate forumlas for each row...? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Question
Why re-invent the wheel?
http://office.microsoft.com/en-us/te...186511033.aspx -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "dramajuana" wrote in message ... That's actually exactly what I've been doing. I was just wondering if there was a forumla I could apply to the column so I didn't have to do that for every row. "tim m" wrote: In your very 1st Row you could enter your debits and credits and this formula in column F: =E2-D2 (assuming your data starts in row two due to headings.) Then in the next cell down in column F put this formula: =F2+E3-D3 Then copy this formula down as needed in column F. It should look at your previous balance (in F) then add the credit and subtract the debit to create a new balance. "dramajuana" wrote: Okay, I don't really know how to word this, so I'm sorry if it sounds awkward. I'm trying to set up Excel so that it can basically be my checkbook registry so that I don't mess up the math. So, I have a column for debits (D), one for credits (E) and one for the running balance (F). Is there a forumla that I can apply to column F that will see what's in D and E for that row, add or subtract what's there, and then apply that to the previous row's F? Or do I just have to do separate forumlas for each row...? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Question | Excel Worksheet Functions | |||
I have a question regarding countif formula. | Excel Worksheet Functions | |||
Formula Question | Excel Discussion (Misc queries) |