I need help with a formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

(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
 
I'm sorry you were right! It seams I had a formula copied into D11 and didnt
see it!!! I looked blank but wasnt!
 
Back
Top