Budget on Numbers

Question

Level 1

5 points

Budget on Numbers

Hi I am in the process of creating a simple spreadsheet for my family's finances on Numbers. I am trying to keep it as basic as possible. In the first column, I have the location of where the money was spent. In the second column, I have if the money is being deposited and I put this in green. In the next column, I have if the money is being withdrawn and that is red. The final column is the total amount in the bank account. I would like to make it so the final column adjusts itself each time I put either a deposit or withdraw in the previous two columns, that way I don't have to consistently recalculate. Is this possible?

Thank you!

MacBook Pro (Retina, 13-inch,Early 2015), macOS Sierra (10.12.5), null

Posted on Jul 17, 2017 5:13 PM

Reply

Answer 1

Jul 17, 2017 6:09 PM in response to link15

you can do something like this:

The formula in cell D2 is:

=IF(COUNTA(B2:C2)>0, SUM($B$1:B2)−SUM($C$1:C2), "")

shorthand for this is:

D2=IF(COUNTA(B2:C2)>0, SUM($B$1:B2)−SUM($C$1:C2), "")

to enter the formula, select cell D2, then type or copy and paste from here, the formula:

=IF(COUNTA(B2:C2)>0, SUM($B$1:B2)−SUM($C$1:C2), "")

to fill down, select cell D2, copy

now select cells D2 thru the end of column D, paste

Reply

Answer 2

Jul 17, 2017 7:20 PM in response to link15

I also feel obliged to mention that Numbers has built-in templates you can pursue using the menu item "File > New…" then look through the template chooser: