If function not working properly

umeshece

New member
Joined
Nov 8, 2019
Messages
2
Reaction score
0
Points
0
Excel Version(s)
10
[h=2]IF Function not working[/h]
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 one cell i want to apply it to whole sheet pls help me to resolve this issue
 
Please attach a sample workbook.
Thank you for your rensponse
Please find the attached sample work book for refference.
In this column M & N are manual data and remainings are real time data
 

Attachments

  • Default MW.xlsx
    16.5 KB · Views: 15
This really isn't of any use whatsoever - sorry.

Excel 2016 (Windows) 32 bit
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
1
Trading symbolLTPBid qtysignalBid rateAsk rateAsk qtyLTQOpenHighLowPrev closeupdownVolume traded todayOpen interestATPTotal bid qtyTotal ask qtyExchangeLTTLUT
2
#N/A####N/A#N/A#N/A#N/A#N/A####N/A#N/A####N/A16001400#N/A#N/A####N/A#N/A#N/A######
3
#N/A####N/A#N/A#N/A#N/A#N/A####N/A#N/A####N/A380400#N/A#N/A####N/A#N/A#N/A######
4
#N/A####N/A#N/A#N/A#N/A#N/A####N/A#N/A####N/A1194011500#N/A#N/A####N/A#N/A#N/A######
5
#N/A####N/A#N/A#N/A#N/A#N/A####N/A#N/A####N/A900800#N/A#N/A####N/A#N/A#N/A######
6
#N/A####N/A#N/A#N/A#N/A####N/A#N/A####N/A#N/A#N/A####N/A#N/A#N/A######
7
#N/A####N/A#N/A#N/A#N/A####N/A#N/A####N/A#N/A#N/A####N/A#N/A#N/A######
8
#N/A####N/A#N/A#N/A#N/A####N/A#N/A####N/A#N/A#N/A####N/A#N/A#N/A######
9
#N/A####N/A#N/A#N/A#N/A####N/A#N/A####N/A#N/A#N/A####N/A#N/A#N/A######
10
#N/A####N/A#N/A#N/A#N/A####N/A#N/A####N/A#N/A#N/A####N/A#N/A#N/A######
11
#N/A####N/A#N/A#N/A#N/A####N/A#N/A####N/A#N/A#N/A####N/A#N/A#N/A######
12
#N/A####N/A#N/A#N/A#N/A####N/A#N/A####N/A#N/A#N/A####N/A#N/A#N/A######
13
#N/A####N/A#N/A#N/A#N/A####N/A#N/A####N/A#N/A#N/A####N/A#N/A#N/A######
14
#N/A####N/A#N/A#N/A#N/A####N/A#N/A####N/A#N/A#N/A####N/A#N/A#N/A######
15
#N/A####N/A#N/A#N/A#N/A####N/A#N/A####N/A#N/A#N/A####N/A#N/A#N/A######
16
#N/A####N/A#N/A#N/A#N/A####N/A#N/A####N/A#N/A#N/A####N/A#N/A#N/A######
17
#N/A####N/A#N/A#N/A#N/A####N/A#N/A####N/A#N/A#N/A####N/A#N/A#N/A######
Sheet: Default MW
 
Back
Top