(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