Same number

[Gregory Ackerman]

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

[#2]

Can you upload an example of what you are trying to achieve? I dont really understand.

[#3]

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

[#4]

Add an IF condition in column F!

cell F4:

=IF(E4="";"";formula you already use for 5000)

[#5]

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

[#6]

I've attached an example of what I think you are trying to do.. have a look and let me know.

[#7]

Yes that looks like it is.

[#8]

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