Trying to use formula IF specific text, then display text from specific cell

Hi there!

I was hoping someone could help me figure out if excel is able to do this,

I'm trying to do a formula that does the following:

IF cell "C2" contains "Formal" return contents of the cell "=G212"
IF cell "C2" contains "Informal" return contents of the cell "=G216"

When I use if functions, the cell does not return anything or gives me a ?Name reject.

I've tried:

=IF(C2=Informal,"=Calculation!G212",IF(C2=Formal,"=Calculation!G216",0))

=IF(C2=Informal,"=Calculation!G212",0)) to see if it would work with just one function and it only dislayed 0

Hi & welcome to the board.
You have the quotes in the wrong place, it should be
=IF(C2="Informal",Calculation!G212,IF(C2="Formal",Calculation!G216,0))

Note your formula & description don't agree.

Thank you so much! That worked perfectly!

Glad to help & thanks for the feedback.