Using a Symbol in a formula.

J

JB in Kansas

I want to display a symbol in a cell, the symbol displayed depends on the
cell next to it being a positive number or negative number. I would like to
have this in the form of a IF(A1>0,TRUE,FALSE) where different symbols would
appear for true and false.

Any one have a way to do this?
 
C

Chip Pearson

First, find the ASCII character code for the symbol you wish to
display. Then use a formula like

=IF(A1>0,CHAR(mmm),CHAR(nnn))



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


message
news:[email protected]...
 
J

Jason Morin

You can return various characters and then change the font to get a symbol.
For example, in B1 you can use:

=IF(A1>0,CHAR(164),CHAR(209))

Format B1 as Webdings. You'll get a clipboard or key. To see the entire
character map in different fonts, type this into row 1 of any cell:

=CHAR(ROW())

and fill down to row 252. Now try different fonts on the column like
Webdings, Wingdings, Marlett, etc.

HTH
Jason
Atlanta, GA
 
Top