ExcelBanter - How to display arrows

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How to display arrows (https://www.excelbanter.com/excel-discussion-misc-queries/184678-how-display-arrows.html)

TUNGANA KURMA RAJU

How to display arrows

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?

Gary''s Student

How to display arrows

Use:
=IF(A1A2,"#",IF(A1<A2,"$",2))
and format to Wingdings 3
--
Gary''s Student - gsnu200781

"TUNGANA KURMA RAJU" wrote:

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?

TUNGANA KURMA RAJU

How to display arrows

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

"Gary''s Student" wrote:

Use:
=IF(A1A2,"#",IF(A1<A2,"$",2))
and format to Wingdings 3
--
Gary''s Student - gsnu200781

"TUNGANA KURMA RAJU" wrote:

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?

All times are GMT +1. The time now is 02:43 PM.