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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting (Icon sets - 3 Arrows) 2
Excel 2007 Chart Data Selection- Arrow Keys Frustration 0
Scrabble Value calculation for Welsh words 0
Apply Conditional Formatting to other rows 6
Percentage max formula? 2
Excel 2007 using arrow keys 1
Arrows And Formulas 2
Extract Formula to Text 6

Back
Top