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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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").
 
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.
 
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").
Click to expand...

Hi HA

Try:

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

Regards

Steve
 
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
 
Back
Top