| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sort Arrows | Excel Discussion (Misc queries) | |||
| Up & Down Arrows | Setting up and Configuration of Excel | |||
| Up/down arrows | Excel Discussion (Misc queries) | |||
| DATA FILTER ARROWS DISPLAY WHILE INACTIVE | Excel Worksheet Functions | |||
| Up Arrows / Down Arrows | Excel Worksheet Functions | |||
Linear Mode
