Spreadsheet: 731346d1620299814-if-and-or-formulas-with-multiple-range-criteria-not-returning-result-book2
Sheet: Sheet1

 |  |  |  |  | [NAME] | Actual Result required
Order Time | Trade No. | Trade Time | Security/ Contract description | Remarks | Security/ Contract description | Security/ Contract description
2:45:57 PM | 875360673 | 2:45:57 PM | FUTIDX BANKNIFTY 29 APR 1998 |  |  | FUTIDX BANKNIFTY 29 APR 1998
2:45:57 PM | 875360674 | 2:45:57 PM | FUTIDX BANKNIFTY 29 APR 1998 |  |  | FUTIDX BANKNIFTY 29 APR 1998
11:41:03 AM | 2154430 | 11:41:23 AM | OPTIDX NIFTY 15 APR 1998 13800 PUT |  |  | OPTIDX NIFTY 15 APR 1998 13800 PUT
11:41:03 AM | 2154457 | 11:41:23 AM | OPTIDX NIFTY 15 APR 1998 13800 PUT |  |  | OPTIDX NIFTY 15 APR 1998 13800 PUT
 |  |  | Scrip Total |  |  | OPTIDX NIFTY 15 APR 1998 13800 PUT
 |  |  | ** Net Del ** |  |  | OPTIDX NIFTY 15 APR 1998 13800 PUT
10:04:56 AM | 125024731 | 10:05:05 AM | FUTIDX NIFTY 29 APR 1998 |  |  | FUTIDX NIFTY 29 APR 1998
10:04:56 AM | 125024732 | 10:05:05 AM | FUTIDX NIFTY 29 APR 1998 |  |  | FUTIDX NIFTY 29 APR 1998
 |  |  |  |  |  | FUTIDX NIFTY 29 APR 1998
 | 0 |  | FUTIDX NIFTY 29 APR 1998 |  |  | FUTIDX NIFTY 29 APR 1998
 |  |  | Scrip Total |  |  | FUTIDX NIFTY 29 APR 1998
 |  |  | ** Net Del ** |  |  | FUTIDX NIFTY 29 APR 1998
11:55:07 AM | 625416620 | 11:56:07 AM | OPTSTK RELIANCE 29 APR 1998 2000 PUT |  |  | OPTSTK RELIANCE 29 APR 1998 2000 PUT
11:55:07 AM | 625416622 | 11:56:07 AM | OPTSTK RELIANCE 29 APR 1998 2000 PUT |  |  | OPTSTK RELIANCE 29 APR 1998 2000 PUT
 |  |  | Scrip Total |  |  | OPTSTK RELIANCE 29 APR 1998 2000 PUT
 |  |  | ** Net Del ** |  |  | OPTSTK RELIANCE 29 APR 1998 2000 PUT
10:28:54 AM | 625254838 | 10:28:54 AM | FUTSTK XYZ 29 APR 1998 |  |  | FUTSTK XYZ 29 APR 1998
10:28:54 AM | 625254898 | 10:28:57 AM | FUTSTK XYZ 29 APR 1998 |  |  | FUTSTK XYZ 29 APR 1998
 |  |  | Scrip Total |  |  | FUTSTK XYZ 29 APR 1998
 |  |  | ** Net Del ** |  |  | FUTSTK XYZ 29 APR 1998
10:29:59 AM | 625256433 | 10:29:59 AM | OPTSTK TCS 29 APR 1998 3200 PUT |  |  | OPTSTK TCS 29 APR 1998 3200 PUT
 |  |  | Scrip Total |  |  | OPTSTK TCS 29 APR 1998 3200 PUT
 |  |  | ** Net Del ** |  |  | OPTSTK TCS 29 APR 1998 3200 PUT
3:04:33 PM | 625685389 | 3:05:09 PM | OPTSTK TCS 29 APR 1998 3520 CALL |  |  | OPTSTK TCS 29 APR 1998 3520 CALL
 |  |  | Scrip Total |  |  | OPTSTK TCS 29 APR 1998 3520 CALL
 |  |  | ** Net Del ** |  |  | OPTSTK TCS 29 APR 1998 3520 CALL
3:09:48 PM | 625696424 | 3:09:48 PM | OPTSTK TCS 29 APR 1998 3700 CALL |  |  | OPTSTK TCS 29 APR 1998 3700 CALL
3:09:48 PM | 625696425 | 3:09:48 PM | OPTSTK TCS 29 APR 1998 3700 CALL |  |  | OPTSTK TCS 29 APR 1998 3700 CALL
 |  |  | Scrip Total |  |  | OPTSTK TCS 29 APR 1998 3700 CALL
 |  |  | ** Net Del ** |  |  | OPTSTK TCS 29 APR 1998 3700 CALL
 | 0 |  | FUTSTK VL 29 APR 1998 |  |  | FUTSTK VL 29 APR 1998
 | 0 |  | FUTSTK VL 29 APR 1998 |  |  | FUTSTK VL 29 APR 1998
 |  |  | Scrip Total |  |  | FUTSTK VL 29 APR 1998
 |  |  | ** Net Del ** |  |  | FUTSTK VL 29 APR 1998
 |  |  | NCL NSE F&O Total |  |  | FUTSTK VL 29 APR 1998
 |  |  |  |  |  | FUTSTK VL 29 APR 1998
9:38:38 AM | 59853 | 9:38:38 AM | OPTCUR USDINR 09 APR 1998 74.25 PUT |  |  | FUTSTK VL 29 APR 1998
9:33:15 AM | 47346 | 9:33:15 AM | OPTCUR USDINR 09 APR 1998 74.50 PUT |  |  | FUTSTK VL 29 APR 1998
 |  |  | Scrip Total |  |  | FUTSTK VL 29 APR 1998
 |  |  | ** Net Del ** |  |  | FUTSTK VL 29 APR 1998
9:37:06 AM | 57704 | 9:37:06 AM | OPTCUR USDINR 09 APR 1998 75 CALL |  |  | FUTSTK VL 29 APR 1998
 |  |  | Scrip Total |  |  | FUTSTK VL 29 APR 1998
 |  |  | ** Net Del ** |  |  | FUTSTK VL 29 APR 1998
 |  |  | NSE CURRENCY Total |  |  | FUTSTK VL 29 APR 1998
 |  |  |  |  |  | FUTSTK VL 29 APR 1998
9:15:00 AM | 25042041 | 9:15:13 AM | xyz CEMENT ISIN:INE383A01012 |  |  | xyz CEMENT ISIN:INE383A01012