Forum Discussion
Excel IF and OR
Hello I am trying to insert a formula: I need text entered into a cell if cell A2 is administration then add Peter, or if cell A2 is Education then add John etc etc. I basically want to add the ...
Hello SelenaJane73
If you're using a new version of Excel (2016 and above), IFS function is all you need.
=IFS(A2="Admin", "Peter", A2="Education", "John", A2="Medical", "Mary", A2="Surgical", "Harry")
Or if you're using an older version:
=IF(A2="Admin", "Peter", IF(A2="Education", "John", IF(A2="Medical", "Mary", IF(A2="Surgical", "Harry", "No Match"))))