formula for percentage w/ arrows

  • Thread starter Thread starter JT
  • Start date Start date
J

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