Hi Everyone, I have a two-parter if you have a minute:
a) Referring to the attached, I'm attempting to make J2 produce "TRUE" if any one of the conditions 1-4 below AND 5 are met, and "FALSE" if not:
1. A2=C2 OR
2. B2=E2 OR
3. B2=I2 OR
4. E2=I2
5. AND F2 contains a number
I tried IF(OR(AND( but came up short.
b) Is it possible to remove "." and any text after it for any stock ticker in column C? For example, if I had "BRKB.X" and "META.Y", in C2 and C3, could I write a formula to produce only "BRKB" and "META", respectively? Something like concatenate?
Thank you for your help.
Bookmarks