(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

How about this:

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

HTH,
Elkar


"j5b9721" wrote:


(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

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

"Elkar" wrote:

How about this:

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

HTH,
Elkar


"j5b9721" wrote:


(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

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" wrote:

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

"Elkar" wrote:

How about this:

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

HTH,
Elkar


"j5b9721" wrote:


(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

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


"Elkar" wrote:

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" wrote:

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

"Elkar" wrote:

How about this:

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

HTH,
Elkar


"j5b9721" wrote:


(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