Excel formula error (not working )

[umeshece]

Hi sir ,
=IF(L8>O8,"BUY",IF(B8>O8,"BUY-F",""))
in the above formula the data in cell no L8 & B8 are Real time data and in O8 Predefined data ,
if when L8 B8 & O8 cells are Real time data then above function is correctly working but when we want to use O8 CELL as predefined value then above function is not working
pls advice to solve this issue

 

[Gerald Higgins]

Hi, welcome to the board.

Please give examples of dates for L8, B8 and O8 where the function works correctly, and ALSO give examples of dates where the function does not work correctly.
ALSO, when you say the function is not working, please explain what exactly you mean - what result is given ?
ALSO, please explain what you mean by "predefined value".

 

[umeshece]

Hi, welcome to the board.

Please give examples of dates for L8, B8 and O8 where the function works correctly, and ALSO give examples of dates where the function does not work correctly.
ALSO, when you say the function is not working, please explain what exactly you mean - what result is given ?
ALSO, please explain what you mean by "predefined value".

---

[TABLE="width: 500"]
<tbody>[TR]
[TD]L8[/TD]
[TD]B8[/TD]
[TD]O8[/TD]
[TD]P8[/TD]
[TD]R8
[/TD]
[/TR]
[TR]
[TD]89[/TD]
[TD]85[/TD]
[TD]95[/TD]
[TD]75[/TD]
[TD]BUY[/TD]
[/TR]
</tbody>[/TABLE]
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 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,