If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
adding arrows
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? |
#2
|
|||
|
|||
adding arrows
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(A1B1,"p","q") formated to wingdings3 or =if(A1B1,"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 "SageOne" wrote: 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? |
#3
|
|||
|
|||
adding arrows
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(B1A1,"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 clickFormat CellsFontFontSelect 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! -------------------- (Ms-Exl-Learner) -------------------- "SageOne" wrote: 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? |
#4
|
|||
|
|||
adding arrows
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. "FSt1" wrote: 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(A1B1,"p","q") formated to wingdings3 or =if(A1B1,"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 "SageOne" wrote: 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? |
Thread Tools | |
Display Modes | |
|
|