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...? |
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...? |
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...? |
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...? |
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...? |
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...? |
All times are GMT +1. The time now is 07:22 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com