Joko Purnomo
Board Regular
- Joined
- Jul 14, 2008
- Messages
- 62
- Office Version
- 2016
- Platform
- Windows
First Position | Second Position | Criteria | Result Formula |
BA | BA | Not RO | AG |
BA | BA | RO | AG |
CRE | CRE | Not RO | CnO |
CRE | CRE | RO | IDB |
CS | CS | Not RO | CnO |
CS | CS | RO | IDB |
INTDB | TSE | RO | IDB |
MA | MA | RO | IHA |
MA | MA | Not RO | IHA |
BCPSR | BCPHN | Not RO | CnO |
Can friends help me to make an if formula in column D (Result Formula), from different conditions for the three columns A, B, C. For example, when column A = "BA", and column B = "BA", and column C = "Not RO", then column D is "AG". Help me from row 2 to 11 in column D (Result Formula), if the condition is false from all of condition (eleven condition), then column D = "CnO".
If my friends who are experts, can volunteer to help my difficulties. Thank you very much ???