If and or

[richmcgill]

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

 

[Fluff]

Maybe something like
=IF(NOT(A1),"",IF(A2="Hello","Emp1",IF(A2="HI","emp2","")))

 

[gaz_chops]

Try

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

 

[richmcgill]

Thank you! Thank worked.