L
lifewings
I want to set up a rent ledger. I have set it up so the rent amount pulls
from a calculation from a cell at the top of the worksheet. This is a two
line ledger sheet. The balance column is meant to keep a running total.
DATE ITEM Check # DEBITS CREDITS BALANCE
06/01/08 Rent $123.00 $123.00
06/10/08 Rent 1111 $0.00 ($123.00) $0.00
07/01/08 $123.00 $123.00
$0.00 $123.00
$123.00 $246.00
What I need to change on this spreadsheet is not showing entries in the
"Debits" or "Balance" columns unless a date or "Rent" in "Item" column is
entered in the same row. I want those cells to be blank and only show
current amounts vs. future amounts. How can this be accomplished?
I would appreciate assistance with this problem.
from a calculation from a cell at the top of the worksheet. This is a two
line ledger sheet. The balance column is meant to keep a running total.
DATE ITEM Check # DEBITS CREDITS BALANCE
06/01/08 Rent $123.00 $123.00
06/10/08 Rent 1111 $0.00 ($123.00) $0.00
07/01/08 $123.00 $123.00
$0.00 $123.00
$123.00 $246.00
What I need to change on this spreadsheet is not showing entries in the
"Debits" or "Balance" columns unless a date or "Rent" in "Item" column is
entered in the same row. I want those cells to be blank and only show
current amounts vs. future amounts. How can this be accomplished?
I would appreciate assistance with this problem.