IF Function not working

  • [h=2]IF Function not working[/h] [INDENT]

    L8B8O8P8R8
    89859575BUY



    My scenario is simple i want to display text in cell R8 when L8>O8,"BUY",B8>O8,"BUY-F",L8< P8."SELL",B8< P8,"SELL-F".
    For this i used function ie =IF(L8>O8,"BUY",IF(B8>O8,"BUY-F",IF(L8< P8."SELL",IF(B8< P8,"SELL-F","")))), Datas in cell L8 & B8,are real time data and in cell O8 &P8 are predefined data (manually feeded or fixed data) when i execute above function it is diplaying "BUY" instead of blank bcz data in L8 is less than O8, but this function is works correctly only when if all cells are have real time data or predefined data,above scenario is an example of only one cell , i want to apply it to whole sheet, pls help me to resolve this issue[/INDENT]

  • Hello and Welcome to the Forum


    Just tested your formula ... which does function as expected ... :smile:


    Do you have an event macro in your sheet module ?


    Do you have your Options Calculation set on Automatic ?

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • Hello,


    You are using the Excel Real Time Data function ... with is linked to a Server for continuous data update ...


    All formulas are updated thanks to the this data feed ...

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!