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

=IF(A10,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


"JB in Kansas" wrote:

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(A10,TRUE,FALSE) where different symbols would
appear for true and false.

Any one have a way to do this?