How to display arrows

T

TUNGANA KURMA RAJU

cell A1=50 and Cell A2=40, in Cell B1 I would like display Up Arrow.
If the value in A1 is less than A2 Down Arrow to be displayed in B1,If A1 is
equal to A2 Equal Arrow.Is this possible?
 
T

TUNGANA KURMA RAJU

Thanks, incase If I format to Wingdings(character codes for the
arrows-241,242,243) then what will be the formula.
 

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

copy and paste the cell with formula ="1" 3
How do I display an arrow in a cell 2
if, then display next cell 4
Formula with Cell reference to include formating? 13
Referencing a cell even if its contents are moved moved/replaced 6
Excel Need Countifs Formula Help 0
Data Validation Error Message 1
How to add conditions to Match function? 3

Top