Simple number to text replacement

[Xtra]

Is there a simple way to replace a number with a text value? I have three levels based on a score. Can I do this without leaving the original cell? For example - Excellent =3, Good = 2, Poor = 1

Also, is there a reverse to this feature? Win = +1 Lose = -1

 

[njimack]

=CHOOSE(A1,"Poor","Good","Excellent")

=IF(A1="Win",1,IF(A1="Lose",-1,""))

 

[PhilW_34]

Hello,

I'm not exactly sure if you want to enter a number and have it change, or just change the text to numbers in existing columns.

You could do a simple find & replace on the columns.

If it can go in a column next to your data, you could do IF formulas.

Will either of these options work for what you want?

Phil

 

[Ruddles]

You can't have a value - like 3, 2, 1 - in a cell as well as a formula which converts it into a different value - excellent, good, poor.

For example, if you have 3, 2 or 1 in cell A1, this formula will return the excellent, good, poor equivalent:-

=CHOOSE(A1,"poor","good","excellent")

But you can't put the formula in A1 otherwise it will overwrite the numeric value upon which it's based.

Any good?

 

[Oaktree]

You could sort of cheat your way there with this number format:

[=1]"Excellent";[=2]"Good";"Poor"

Note that anything not = to 1 or 2 would show as "Poor"... but, so long as {1,2,3} are your discrete possibilities, that would be OK.

 

[Xtra]

That is it! All good stuff. But the problem was it was not a formula I was seeking for that.
Thx!

 

[Xtra]

Njimack - The IF solved my secondary desire. Thx, again!