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 |
| 4706.53 |
| 4706.53 |
| 4706.53 |
| 4706.53 |
| 4706.53 |
| 4706.53 |
| 4706.53 |
| 4706.53 |
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 Add an IF condition in column F!
cell F4:
=IF(E4="";"";formula you already use for 5000)
