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

L

Lee Mitchell

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
 
J

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
 
Top