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
5 replies
Sort By: 

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

you can do something like this:

User uploaded file


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

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Budget on Numbers

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.