ExcelBanter - If Formular Problem, Need Help!

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - If Formular Problem, Need Help! (https://www.excelbanter.com/excel-discussion-misc-queries/166987-if-formular-problem-need-help.html)

PeterH

If Formular Problem, Need Help!

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.

Farhad

If Formular Problem, Need Help!

Hi,

Here is the correct formula:

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

Thanks,
--
Farhad Hodjat

"PeterH" wrote:

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.

PeterH

If Formular Problem, Need Help!

Farhad,

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

Regards Peter.

"Farhad" wrote:

Hi,

Here is the correct formula:

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

Thanks,
--
Farhad Hodjat

"PeterH" wrote:

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.

All times are GMT +1. The time now is 06:05 AM.