Formula With Many Conditions

I am working on a spreadsheet for work and am needing help. Continuity Spreadsheet.xlsx In this spreadsheet, I am trying to get it set up where A11 automatically fills in when I put the provider in G8 based on their position and team.

Here is what I am trying to auto populate:

"Same Resident" if G8=A1
"Resident Same Team" if G8<>A1,G9=Resident,G10=D1
"Faculty Same Team" if G8<>A1,G9=Faculty,G10=D1
"APRN" if G9=APRN
"Resident Different Team if G8<>A1,G9=Resident,G10<>D1
Faculty Different Team if G8<>A1,G9=Faculty,G10<>D1


Is this too me conditions or is there a way of doing this? Thank you.

*<> means not equal to

Try this:

=IF(G8=A1,"Same Resident",IF(G9="APRN","APRN",IF(G9="Resident",IF(G10=D1,"Resident Same Team","Resident Different Team"),IF(G9="Faculty",IF(G10=D1,"Faculty Same Team","Faculty Different Team"),""))))

Hope this helps.

Pete

Worked great. Thank you.