• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Inserting Symbols in Formula

grumpus

New Member
I am working with Excel 2007 and am befuddled as to why this formula won't work:


=IF($N$5=2,CHAR(232),"")


Char (232) is supposed to be a bold right pointing arrow as noted on the insert symbol wingdings screen. However, when the statement is TRUE it shows this as a result of the TRUE statement: è


Can anyone help?


Mike
 
Hi Mike ,


Just format the cell as Wingdings. The formula alone , just puts that value in the cell ; formatting the cell as Wingdings will display the right pointing arrow.


Narayan
 
I am learning so much on this forum and am creating more complex formulas based upon this new knowledge. Changing the formatting never occured to me. Thanks so much for helping me solve this so quickly!


Mike
 
GOOD DAY grumpus


With time on your hands you can have a bit of fun with NARAYANK991 advice


https://dl.dropbox.com/u/75495784/FUNTIME.xlsx
 
Back
Top