adding arrows

[SageOne]

I have an IF function that determines if one cell is greater than another
cell.....is there a way to display and up or down arrow as the result of an
IF function in excel 2003?

 

[FSt1]

hi
possibly.
format the cell to wingding3, then use the lower case p and lower case q.
the lower case p will produce an upward pointing arrow head (pyramid??) and
the lower case q will produce a downward pointing arrow head. when needed,
this is what i use.
you might try the upper case J for upward point double arrows and upper case
L for downward pointing double arrows.

so that the formula would look like
=if(A1>B1,"p","q") formated to wingdings3
or
=if(A1>B1,"J","K")

there may be other symbols that you might like better but that might require
tracking them down. this is just what i have used when needed.

Regards
FSt1

 

[Ms-Exl-Learner]

Assume that you are having values in A1 & B1 Cell like the below.

A1 cell
160

B1 cell
180

In C1 paste this formula
=IF(B1>A1,"p",IF(B1=A1,"w","q"))
In formula DON’T change the “pqw†characters to uppercase.

Now place the cursor in C1 cell and do right click>>Format
Cells>>Font>>Font>>Select the Font “Wingdings 3†press ok. Otherwise press
Cntrl+Shift+F and select the “Wingdings 3†font.

Type 120 in B1 cell and again type 160 in B1 cell to see the C1 cell results.

Hope this is what you are looking for.

Remember to Click Yes, if this post helps!

 

[Minty Fresh]

You could also use the [Symbol] option under the [Insert] menu.
Upon selecting this option, a character matrix will be displayed. Find an
arrow you like and click the [Insert] button to enter it into the currently
selected cell.
You can then either copy the symbol from the cell and paste it directly into
your formula enclosed by quotation marks "⇩", or refer to the cell in which
the symbol was entered in the formula.