I have a spreadsheet set up calculate debits and credits and to update the running balance.
I would like to have the balance updated after each entry but to NOT continue down the column repeatedly in those cells that have no entries.
Yes. I CAN pull the formula down as I need to, but I would like it to update without my further action on my part.
I tried using the IF function but it would not work for me. I told the first empty cell in the running balance column, IF (the two adjacent cells) = Zero then running balance column would be blank. IF (the two adjacent cells were greater than zero, then running balance cell plus amount owed less amount paid = new running balance.
It didn't work. Is the answer in front of me and I am not seeing it? LOL Thanks for both your time and effort!