Forum Discussion
Same number
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)
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
