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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find previous number and find next number in column 4
PMT calculator 8
Stripe out duplicate data 5
Help needed with a formula or macro 1
Using IF function then Autofill-increments down a reference cell 2
Need a function 1
Conditional formatting a whole column but with the conditions < & 1
DateRange Lookup no exact match, can't use lesser 4

Back
Top