If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Optimizing this formula?
I have three columns and only calculating col 2. I have a heading so my
calculation starts from row 2. But here is the task. 1) row 2 is my opening balance. 2) every row after this is a amount that is subtracted from the row 2. 3) the last row will contain the closing balance. I'm creating a monthly budget and this is what I'm able to do so far. A) {=B2-(SUM(ABOVE))} BUT, I can't seem to add an extra field to subtract the extra balance. B) I used {=B2-SUM(B3:B10)} BUT, I don't want to keep changing the last row number. Any suggesting on how to optimize this or am I stuck with making the last row number change? -- Coding is like a box of chocolates!... |
Thread Tools | |
Display Modes | |
|
|