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
"HA@Work" wrote:

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(D9C9,"Improvement","Regression").