Aug 11 2018 11:24 AM
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 |
Aug 11 2018 01:18 PM
Can you upload an example of what you are trying to achieve? I dont really understand.
Aug 12 2018 06:51 AM
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 |
Aug 12 2018 07:39 AM - edited Aug 12 2018 07:39 AM
Add an IF condition in column F!
cell F4:
=IF(E4="";"";formula you already use for 5000)
Aug 12 2018 09:47 AM
Don't understand the IF command. Figure 1 is what is now, figure2 the formulas, figure 3 what I am trying to gain.
Figure 1.
Deposits | Name | Withdrawals | BALANCE |
20000 | 4800 | ||
SCOTT-Partial share | 15000 | 4800 | |
GREG- fee | 200 | 4800 | |
4800 | |||
4800 | |||
4800 | |||
4800 | |||
20000 | 15200 | 4800 | |
4800 |
Figure 2
Deposits | Name | Withdrawals | BALANCE |
20000 | =SUM(C9-E9) | ||
SCOTT-Partial share | 15000 | =SUM(C9-E9) | |
GREG- fee | 200 | =SUM(C9-E9) | |
=SUM(C9-E9) | |||
=SUM(C9-E9) | |||
=SUM(C9-E9) | |||
=SUM(C9-E9) | |||
=SUM(C2:C8) | =SUM(E2:E8) | =SUM(C9-E9) | |
=SUM(C9-E9) |
Figure 3
Withdrawals | BALANCE |
15000 | 5000 |
200 | 4800 |
15200 |
I don't want the next line in F to be filled till inputted in E. Also I want F to keep the previous total. Does that make sense? I am learning on the fly here.
Thanks
Aug 12 2018 10:37 AM
I've attached an example of what I think you are trying to do.. have a look and let me know.
Aug 13 2018 12:21 PM - edited Aug 13 2018 12:22 PM
instead of =SUM(C9-E9) I was saying to use
=IF(E9="";"";SUM(C9-E9))
also, remember that it is C9-E9 then C10-E10 and so on