tonyrensya
New Member
- Joined
- Jul 24, 2013
- Messages
- 21
- Office Version
- 2019
- Platform
- Windows
- MacOS
Hello all,
I'm using Excel 2019, here is my problem to be solve:
If value is A1 or A2, returns 1
If value is B1 or B2, returns 0
Great thanks to all
I'm using Excel 2019, here is my problem to be solve:
If value is A1 or A2, returns 1
If value is B1 or B2, returns 0
Data | value |
Tom | A1 |
John | B1 |
Mary | A2 |
May | B2 |
Outcome | Returns |
Mary | 1 |
Tom | 1 |
May | 0 |
John | 0 |
Great thanks to all