Function that returns symbols as formula result eg up/down arrow?

CP Smith · Oct 20, 2006

Where a formula result is negative I would like a down arrow to appear,
positive and upward arrow and if zero a sideways arrow - can this be done

Gary''s Student · Oct 20, 2006

=IF(A1+B1>0,5,6) and format the cell as WingDings 3

Teethless mama · Oct 20, 2006

=IF(A1>0,CHAR(225),IF(A1<0,CHAR(226),CHAR(224)))

Use the "Wingdings" format