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
.
|