Hi, I'm going around in circles trying to figure out how to do multiple IFS based on the contents of 2 cells.....
I'm not sure I've explained that very well, but hopefully this may help!
Sequence
1. If Col B is blank, do nothing, if not…
2. If Col C contains "alpha", return alpha into Column D
3. If Col C contains "beta", return beta into Column D
4. If Col C contains neither "alpha" nor "beta", return "not found" into Column D
I'm not sure I've explained that very well, but hopefully this may help!
Sequence
1. If Col B is blank, do nothing, if not…
2. If Col C contains "alpha", return alpha into Column D
3. If Col C contains "beta", return beta into Column D
4. If Col C contains neither "alpha" nor "beta", return "not found" into Column D
mulltiple-conditions-&-possibilities-for-mutiple-ifs.xlsx | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | Row | Info-1 | Info-2 | Goal | Reasoning | Sequence | |||
2 | 2 | 3 | text contains alpha | alpha | Col B is NOT blank, Col C contains alpha | 1. If Col B is blank, do nothing, if not… | |||
3 | 3 | alpha | Col B is blank, so nothing | 2. If Col C contains "alpha", return alpha | |||||
4 | 4 | 5 | beta | beta | Col B is NOT blank, Col C contains beta | 3. If Col C contains "beta", return beta | |||
5 | 5 | text contains beta | Col B is blank, so nothing | 4. If Col C contains neither "alpha" or "beta", return "not found" | |||||
6 | 6 | 2 | not found | Col B is NOT blank, Col C does NOT contain either alpha or beta | |||||
7 | 7 | Col B is blank, so nothing | |||||||
8 | 8 | 5 | ___ ALPHA ____ | alpha | Col B is NOT blank, Col C contains alpha | ||||
9 | 9 | 8 | ____BETA____ | beta | Col B is NOT blank, Col C contains beta | ||||
10 | 10 | ____BETA____ | Col B is blank, so nothing | ||||||
Sheet1 |