Excel IF...THEN

Discussion in 'Trading Software' started by FuturesTrader71, Jun 24, 2005.

  1. Quiet1

    Quiet1

    Bid
    =INDEX(A2:A13,COUNTIF(A2:A13,">"&A15)+1,1)
    Ask
    =INDEX(A2:A13,COUNTIF(A2:A13,">"&A15),1)

    :confused:
     
    #11     Jun 24, 2005
    Share
  2. FuturesTrader71

    FuturesTrader71

    That worked. I didn't enter it correctly. I have never used the INDEX function, so this is a welcome lesson.

    I appreciate your help.
     
    #12     Jun 24, 2005
    Share