ExcelBanter - Function that returns symbols as formula result eg up/down arrow?

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Function that returns symbols as formula result eg up/down arrow? (https://www.excelbanter.com/excel-worksheet-functions/115383-function-returns-symbols-formula-result-eg-up-down-arrow.html)

CP Smith

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

Gary''s Student

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

Teethless mama

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

All times are GMT +1. The time now is 12:13 PM.