Hi, how do I test 2 conditions where one condition has 2 possibles?
In Row _ , IF Column A contains "CALL", AND Column B contains "Buy" or "Acquisition", enter result in Column F | |||||||||
A | B | C | D | E | F | Result | |||
Buy | company1 | 40 | 157.870 | (6,321.80) | |||||
CALL | Buy | CALL-100 ADSK'20 JA@175 OPENING TRANSACTION EXPIRES ON JAN 17,2020 JK-200187 | 4 | 5.500 | (2,212.00) | (2,212.00) | |||
CALL | Sell | CALL-100 HRTX'20 SP@25 CLOSING TRANSACTION EXPIRES ON SEP 18,2020 LH-231912 | (20) | 0.600 | 1,167.97 | ||||
PUT | Buy | PUT -100 XLNX'19 OC@105 OPENING TRANSACTION EXPIRES ON OCT 18,2019 UJ-191183 | 2 | 6.450 | (3,872.50) | ||||
PUT | Sell | PUT -100 AAL'20 JN@6 OPENING TRANS - UNCOVERED EXPIRES ON JUN 19,2020 JB-240045 | (2) | 0.510 | 92.49 | ||||
CALL | Acquisition | CALL-100 AAPL'19 SP@35 CLOSING TRANSACTION EXPIRES ON OCT 02,2020 LT-34092 | 331 | (2,197.00) | (2,197.00) |