What is the Excel Forumula To Create a Letter For Both Minus Numbers and Pluse Numbers?

[zotah]

What is the Excel Formula To Create a Letter To Represent a Minus Number and another Letter To Create a Plus Number and Another Letter to Create a zero (0) Value or No number.

So Let's say I have

4 and I want this Positive 4 to be translated into another cell as the Letter (R) for example

-3 and I want this negative number to be translated into another cell as the Letter (G) for example

8 and I want this Positive 8 to be translated into another cell as the Letter (R) for example

0 (zero) and I want the (0) (zero) to be translated into another cell as the Letter (Q) for example

-12 and I want this negative number to be tranlated into another cell as the Letter (G) for example

So no matter what the number is I need to know if there is a formula that I can use to tranlate any 3 types of numbers (Negative Number for One Letter) (Positive Numbers for One Letter) and (All "0" only Numbers to be One Letter)


Thus giving one of the 3 answers of (R) (Q) or (G) depending upon whether this digit is Positive, Negative or (zero)

So if the number is -158 or -56 or -985 or -2 (All these negative numbers would all return a result of the letter G

and other number of any kind that are all possitive numbers like 57 or 225 or 37 or even the number 6 will a return a result of the letter R in a separate cell where the formula is located and

Lastly if the number is only (0) zero (which really isn't a number at all) comes up I need it to return a result of the letter Q

Do you know of a simple formula I can use to tranlate all these 3 types of numbers all in the same one formula that I can slide the forumula down a list of any columns figuring out every single number all the way down hundreds of cells.

Thanks

 

[Fazza]

how about,

=LOOKUP(SIGN(A1),{-1,0,1},{"G","Q","R"})
=CHOOSE(SIGN(A1)+2,"G","Q","R")
=IF(A1<0,"G",IF(A1>0,"R","Q"))

 

[zotah]

Formula Works Perfectly

Thanks So Much

Gary

 

[Fazza]

you're welcome, Gary.

all the best