Hello,
I have formula that calculates on each row. I would like to copy the formula down several rows, however the last value stays in the rows that have no data to calculate.
Sample:
Income Expense Balance
2200 1100 1100 (formula: =a2-b2)
500 600 (formula: =c2-b2)
600 (formula: =c3-b3)
600
600
I once had a formula that would make the value "0" until values were added. I can't remember how I did it. Do you have any ideas?
--Sandy
I have formula that calculates on each row. I would like to copy the formula down several rows, however the last value stays in the rows that have no data to calculate.
Sample:
Income Expense Balance
2200 1100 1100 (formula: =a2-b2)
500 600 (formula: =c2-b2)
600 (formula: =c3-b3)
600
600
I once had a formula that would make the value "0" until values were added. I can't remember how I did it. Do you have any ideas?
--Sandy