richmcgill

New Member
Joined
Feb 4, 2019
Messages
27
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
 

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
46,340
Office Version
  1. 365
Platform
  1. Windows
Maybe something like
=IF(NOT(A1),"",IF(A2="Hello","Emp1",IF(A2="HI","emp2","")))
 

gaz_chops

Well-known Member
Joined
Apr 29, 2003
Messages
6,468
Platform
  1. MacOS
Try

=IF(AND(A1=TRUE,A2="Hi"),"Employee A",IF(AND(A1=TRUE,A2="Hello"),"Employee B",""))
 

Watch MrExcel Video

Forum statistics

Threads
1,109,028
Messages
5,526,336
Members
409,696
Latest member
EERS

This Week's Hot Topics

Top