richmcgill
Board Regular
- Joined
- Feb 4, 2019
- Messages
- 86
- Office Version
- 2016
- Platform
- Windows
I need one formula that will display information based on three different variables. Does the below make sense?
If cell A1 equals = True
If cell A2 equals = Hello
Cell A3 will Display = Employee A
If cell A1 equals = True
If cell A2 equals = HI
Cell A3 will Display = Employee B
If cell A1 is False then cell A3 will remain blank
If cell A1 equals = True
If cell A2 equals = Hello
Cell A3 will Display = Employee A
If cell A1 equals = True
If cell A2 equals = HI
Cell A3 will Display = Employee B
If cell A1 is False then cell A3 will remain blank