how to insert a special character (arrow) in IF statement

[Guest]

How do I use arrows in my IF statement? Insead of "Improvement" in the
formula below, I want to show an arrow pointing upwards and instead of
"Regression" I want to show an arrow that points downward.
=IF(D9>C9,"Improvement","Regression").

 

[Guest]

one way:

Insert=>Symbol -> select Up arrow and insert in a cell: repeat for Down arrow.

=IF(D9>C9,X1,X2) where X1 & X2 hold the symbols.

 

[Scoops]

How do I use arrows in my IF statement? Insead of "Improvement" in the
formula below, I want to show an arrow pointing upwards and instead of
"Regression" I want to show an arrow that points downward.
=IF(D9>C9,"Improvement","Regression").

Hi HA

Try:

=IF(D9>C9,"â","á") and set the cell font to Wingdings

Regards

Steve

 

[Guest]

the simplest way is to look at fonts with arrows like wingdings or some of
the others

format the cell with the font you want and have your if statement be
=if(criteria,h,i) if font is windings3