Numbers checkbook register template
Does anyone have a useful checkbook register template to use with Numbers?
MacBook Pro, macOS Sierra (10.12.1)
Does anyone have a useful checkbook register template to use with Numbers?
MacBook Pro, macOS Sierra (10.12.1)
There is not a checkbook registry built-in but you can make one by entering the column names:
then make the first row a header row by using the contextual menu for the row:
Then add the formula in the column for "Balance"
E2=IF(D2<>"", SUM($D$2:D2), "")
this is shorthand for... select cell E2 then type (or copy and paste from here) the formula:
=IF(D2<>"", SUM($D$2:D2), "")
to fill down, select cell E2, copy
now select cells E2 thru the end of column E, paste
if you would rather have a debit and credit column, try something like this:
use the formula:
F2=IF(OR(D2≠"", E2≠""), SUM($D$2:D2)−SUM($E$2:E2), "")
fill F2 down like before
There is not a checkbook registry built-in but you can make one by entering the column names:
then make the first row a header row by using the contextual menu for the row:
Then add the formula in the column for "Balance"
E2=IF(D2<>"", SUM($D$2:D2), "")
this is shorthand for... select cell E2 then type (or copy and paste from here) the formula:
=IF(D2<>"", SUM($D$2:D2), "")
to fill down, select cell E2, copy
now select cells E2 thru the end of column E, paste
if you would rather have a debit and credit column, try something like this:
use the formula:
F2=IF(OR(D2≠"", E2≠""), SUM($D$2:D2)−SUM($E$2:E2), "")
fill F2 down like before
Thank you.
Numbers checkbook register template