If Formular Problem, Need Help!

[Guest]

I am trying to setup a formular to bring in a persons name if a symbol is
entered into 1 of 3 cells, I have "Smilley" symbole in cell "U2" & the
formular I am trying is:
=(IF(D9=U2,"GRANT PICTON","",(IF(F9=U2,"PAUL BELL","",(IF(H9=U2,"PETER
HUWILER",""))))))

Need Help.

 

[Guest]

Hi,

Here is the correct formula:

=IF(D9=U2,"GRANT PICTON",IF(F9=U2,"PAUL BELL",IF(H9=U2,"PETER
HUWILER","")))

Thanks,

 

[Guest]

Farhad,

Thank you very much. Well done. This will be a great help.

Regards Peter.