Simple Cash Flow worksheet formula

Question

Level 1

0 points

Simple Cash Flow worksheet formula

What is the best way to do a simple cash flow formula (Income, Expense, Total)?
I'd like it to be like a checkbook but with auto calculation.

For example
Column A = Income
Column B = Expense
Column C = Total of line

In Excel you can use an asterisk (*) to formulate multiple cells (something I've been unable to figure out in Numbers).

It seems the only way I can do this is if I manually enter a formula for EACH cell.
Any tips?

MacBook Pro Dual Core 2ghz, Mac OS X (10.4.7), logic pro 7, ableton live, reason

Posted on Apr 21, 2008 9:57 AM

Reply

Answer 1

pw1840

Level 3

860 points

Apr 21, 2008 11:37 AM in response to prospect

prospect,

Are you tying to copy formulas down a column? If so, select the cell or group of contiguous cells you want to copy. the click on the little circle in the lower right of the selection. The cursor becomes a little black +. Drag this cross down to the end of the column. Or, type your formulas in the header of the columns. If everything below is blank, those cells will take on the formula in the header.

pw

Reply

Answer 2

prospect Author

Level 1

0 points

Apr 21, 2008 12:08 PM in response to pw1840

Wow that is cool!

Is there a way to have a checkbook style formula?

For example if I put a specific amount in A2 (income) it will add to the balance on C2.
Conversely if I input a number in B3 (expense) it will subtract from C2 and put a result in C3 (total).

(A* = Income, B* = Expense, C* = Total)

Reply

Answer 3

pw1840

Level 3

860 points

Apr 21, 2008 1:17 PM in response to prospect

prospect,

The typical checkbook style cash flow table you describe is shown below. Thee Balance formula is:

=IF(AND(D3="",E3=""),"",F2-D3+E3). The AND simply keeps the Balance cell blank until until either a payment or deposit is entered in the row. Also note that row 2 is left blank thus becoming an implied zero in column F for the first Balance formula. You should have little trouble adapting this to you situation.

pw

User uploaded file

Reply