Need assistance with if statement

[RinorM]

Hi,

I wanna create the following scenario:

If the value in cell S116 is picked from T95 then display the text in O92, If the value in cell S116 is picked from T100 then display the text in O97, If the value in cell S116 is picked from T108 then display the text in O102


Does anyone have a clue on how to do this?

Regards,

[Special-K]

If by "picked from" you mean "is equal to" then try

=IF(S116=T95,O92,IF(S116=T100,O97,IF(S116=T108,O102,"OTHER")))

[RinorM]

It worked fine, thank you.