Index formula questions [Closed]

Report
Posts
1
Registration date
Monday July 17, 2017
Status
Member
Last seen
July 17, 2017
-
I have an index formula that will be calculating price points based on the values entered into the excel document. Is there a way to make sure that there isn't a value showing in the cell that has the formula until a value is entered into one of the other cells?

Here is the formula: =INDEX(D6:D11, SUMPRODUCT(--($L$8<=C6:C11), --($L$8>=B6:B11), ROW(A1:A6)))

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!