formula for percentage w/ arrows

[JT]

I need help with a formula that will caculate the
difference between two cells and then display an up or
down arrow depending on difference. I believe it starts
like: =IF(A3>A3,"h","i")

The value in the cell shows "i" with the above formula.
But how do I get it to display the up or down arrow
instead of the letter?

Please help.

Thanks,
JT

 

[Frank Kabel]

Hi

fist format the target cells with the font "Symbol". then you can
change your formula to
=IF(A3>X,char(173), IF(A3<X,char(175),char(174)))


HTH
Frank