Inserting arrows into an If() Statment - not working - help

[ajh1313]

I would like to insert arrows into an IF() formula in excel for my performance dashboard. I am trying to insert the up arrow, down arrow and side to side arrow using alt+0241, alt+0242, and alt+0243. For some reason the arrows are not showing up. Just these symbols are showing up - ñ, ò, ó

Not sure what the problem is. Thanks for the help.

aj

 

[George J]

Not sure if you are trying to use Unicode characters instead of Ascii characters.
As far as I recall, Ascii doesn't have all the arrows, just < > ^

If you wanted Unicode characters, then you would need a user defined function
UNICHAR function - Excel - Office.com

 

[bschwartz]

Try changing the font to Wingdings.

 

[Linus_99]

Have you considered using Conditional Formatting instead ? (You get the arrows automatically as part of an icon set).

 

[bschwartz]

Try changing the font to Wingdings.

Note: To use in formula, you would need to use the CHAR function. So something like CHAR(241) inside the IF. Then change font to Wingdings.