| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function that returns symbols as formula result eg up/down arrow?
Where a formula result is negative I would like a down arrow to appear,
positive and upward arrow and if zero a sideways arrow - can this be done |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function that returns symbols as formula result eg up/down arrow?
=IF(A1+B10,5,6) and format the cell as WingDings 3
-- Gary's Student "CP Smith" wrote: Where a formula result is negative I would like a down arrow to appear, positive and upward arrow and if zero a sideways arrow - can this be done |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function that returns symbols as formula result eg up/down arrow?
=IF(A10,CHAR(225),IF(A1<0,CHAR(226),CHAR(224)))
Use the "Wingdings" format "CP Smith" wrote: Where a formula result is negative I would like a down arrow to appear, positive and upward arrow and if zero a sideways arrow - can this be done |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rs.10,250.00 formula Rupees ten thousand two hundred fifty only | New Users to Excel | |||
| VBA | Excel Worksheet Functions | |||
| EXCEL:NUMBER TO GREEK WORDS | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Amount or Numbers in Words | New Users to Excel | |||
Linear Mode
