I have created a simple formula to calculate a balance, my formula is
=D2+A3-B3-C3. The balance displays correctly cell D3, but the once I copy and paste my formula to the bottom of my worksheet the the balance cell D3 also displays to the bottom of my worksheet. How do I prevent this from happening. I would like cells D4, D5, D6 and so on to display a zero balance until the appropriate data is input.
=D2+A3-B3-C3. The balance displays correctly cell D3, but the once I copy and paste my formula to the bottom of my worksheet the the balance cell D3 also displays to the bottom of my worksheet. How do I prevent this from happening. I would like cells D4, D5, D6 and so on to display a zero balance until the appropriate data is input.
