Forum Discussion
Same number
I get the same number all the way down the column, I am looking for a way to have IE: F2 be 3993 and F3 on to be blank until next entry. BALANCE 4706.53 4706.53 4706.53 4706.53 4...
Can you upload an example of what you are trying to achieve? I dont really understand.
I am trying to get rid of the numbers in cells/rows I have not entered data on, IE: F2 & F3 should have the 5000 in but not F4 on until I enter a number in E4. When I go and try to remove the 5000 on F4 on down it deletes the formula, and I have to re-enter it each time I enter new data.
| Name | Withdrawals | BALANCE |
| 5000 | ||
| SCOTT-Partial share | 15000 | 5000 |
| GREG- fee | 5000 | |
| 5000 | ||
| 5000 | ||
| 5000 | ||
| 5000 | ||
| 5000 | ||
| 5000 | ||
| 5000 | ||
| 5000 |