Forum Discussion
SelenaJane73
Dec 20, 2023Copper Contributor
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 ...
Harun24HR
Dec 20, 2023Bronze Contributor
SelenaJane73 Try nested IF() formula-
=IF(H2="Admin","Peter",IF(H2="Education","John",IF(H2="Medical","Mary",IF(H2="Surgical","Harry","Something Else"))))