ExcelBanter - how do I assign a symbol to the result of a part of a nested IF s.

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - how do I assign a symbol to the result of a part of a nested IF s. (https://www.excelbanter.com/excel-worksheet-functions/19843-how-do-i-assign-symbol-result-part-nested-if-s.html)

Lee Mitchell

how do I assign a symbol to the result of a part of a nested IF s.

I am trying to assign a symbol to a result of a nested IF statement and I can
not determine a method of doing this. Please help

Jason Morin

As an example:

=IF(D20=1,CHAR(74),IF(D20=2,CHAR(76),""))

Format the cell as Wingdings. 1 = smiley face, 2 = frown
face. To see available symbols, type =CHAR(ROW()) in row
1 and copy the down to row 252. Format the cells as
Wingdings (or Webdings, etc.)

HTH
Jason
Atlanta, GA

-----Original Message-----
I am trying to assign a symbol to a result of a nested
IF statement and I can
not determine a method of doing this. Please help
.

All times are GMT +1. The time now is 10:16 AM.