# IF Function not working

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

 L8 B8 O8 P8 R8 89 85 95 75 BUY

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

• Thank you for your response ,
please check the work book attached below, in this work book M & N column data are manual data and remaining datas are live data (real time data), no event macro in this sheet , and no option calculation set in this workbook

## Files

• 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!