Insert a symbol

**Lloydee** · 08-12-2007, 05:38 AM

Hi Guys.
I’m trying to insert a symbol into a cell depending on whether another cell contains a positive or negative number.
I.e. a ↑ for a positive number ↓ for a negative number & ↔ for a zero.
Any help is much appreciated.

Thanks.

Lloydee.

**mudraker** · 08-12-2007, 08:09 AM

As a formula

=IF(A1<0,"↓",IF(A1>0,"↑","↔"))

**daddylonglegs** · 08-12-2007, 08:09 AM

Here's one way, assuming the cell with the number is A1 use this formula in another cell

=CHAR(CHOOSE(SIGN(A1)+2,175,171,173))

then use Format > Cell > Font and change to "Symbol"

**Ron Coderre** · 08-12-2007, 08:34 AM

From your post, you want to use these symbols to flag delta values, right?

Please Login or Register  to view this content.

Try this

1) Put those 3 characters in a cell, in this order:
↓↔↑

2) Now build this kind of formula around them:
=CHOOSE(SIGN(A1)+2,"↓","↔","↑")

If A1 is positive, it returns: ↑
If A1 is negative, it returns: ↓
If A1 is zero, it returns: ↔

Is that something you can work with?

Insert a symbol

LinkBack

Thread Tools

Rate This Thread

Display

Insert a symbol

Insert a symbol

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions