Hi sir
I am using the Excel Real Time Data function ... which is linked to a Server for continuous data update. My scenario is i want to display text in a cell when Cell A>E,"BUY", B>E,"BUY-F", A<D,"SELL",B<D,"SELL-F", For this I used function ie" =IF(A>E,"BUY",IF( B>E,"BUY-F",IF( A<D,"SELL",IF(B<D,"SELL-F",""), this function works perfectly for all sheets(normal workbook) and my live sheet workbook(only when all cells are live data) also , but in my live sheet i added one more column which contains manual datas( predefined or fixed data). In the above scenario column E &D are manual feeded (data), in this scenario (ie comparing live data with contant data )this funtion is not working,it is displaying "buy" all time irrespective of datas in cell E & CELL D, pls help me to resolve this issue
I am using the Excel Real Time Data function ... which is linked to a Server for continuous data update. My scenario is i want to display text in a cell when Cell A>E,"BUY", B>E,"BUY-F", A<D,"SELL",B<D,"SELL-F", For this I used function ie" =IF(A>E,"BUY",IF( B>E,"BUY-F",IF( A<D,"SELL",IF(B<D,"SELL-F",""), this function works perfectly for all sheets(normal workbook) and my live sheet workbook(only when all cells are live data) also , but in my live sheet i added one more column which contains manual datas( predefined or fixed data). In the above scenario column E &D are manual feeded (data), in this scenario (ie comparing live data with contant data )this funtion is not working,it is displaying "buy" all time irrespective of datas in cell E & CELL D, pls help me to resolve this issue