| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conversion | Excel Worksheet Functions | |||
| Amount or Numbers in Words | New Users to Excel | |||
| Is there a formula to spell out a number in excel? | Excel Worksheet Functions | |||
| Convert Numeric into Text | Excel Worksheet Functions | |||
| Spellnumber | Excel Worksheet Functions | |||
Linear Mode
