I need help with a formula

[j5b9721]

(C 10) is a constant # in C columb
(D 10) is entered daily
(E 10) has =IF(C10="","",(D10-D9)/C10)
its copied and pasted down the page in E columb

I need the empty cell (E 11) to be nothing or 0 until (D 11) is entered.
The reason is I'm looking to average the % cells in E columb (that is done)

Invested Daily Gain Daily %
(C 9) (D 9) (E 9) has this =IF(C9="","",(D9-D8)/C9)
60.00 3.33 0.010

(C 10) (D 10) (E 10) has this =IF(C10="","",(D10-D9)/C10)
60.00 3.93 0.010

(C 11) (D 11) (E 11) has this =IF(C11="","",(D11-D10)/C11)
60.00 -0.066 with this when nothing is entered in D11

 

[Elkar]

How about this:

=IF(OR(C11="",D11=""),"",(D11-D10)/C11)

HTH,
Elkar

 

[j5b9721]

It dont work... I keep getting the same result....

 

[Elkar]

Double check that you typed it correctly. This works fine for me. If either
C11 or D11 are blank, then there should be no result displayed.

HTH,
Elkar

 

[j5b9721]

I'm sorry you were right! It seams I had a formula copied into D11 and didnt
see it!!! I looked blank but wasnt!