Format Number Based On Number

[Al Delgado]

I have columns with ratings between 1 and 5, I would like to add descriptive text based on the rating with custom formatting. Is it possible to do this?

5 Ex
4 VG
3 G
2 Fair
1 Poor

Thanks
Al

 

[Luke M]

You would need to use a helper cell. Easiest formula might be something like:
=A2&" "&CHOOSE(A2,"Poor","Fair","G","VG","Ex")

Custom number formatting doesn't give you enough conditions to be able to have all of those within a regular number format.

 

[Al Delgado]

With the custom number formatting how many conditions would I be able to do?

 

[Luke M]

Two, maybe 3 if you have a "default" status. Here's an example custom format:
[>2]# "Good";[<=1]# "Poor";# "Ok"

This setup would cause any number greater than 2 to be flagged "Good", anything <= 1 to be "Poor", and everything else would be "Ok".

 

[Al Delgado]

Thanks for the help, I can make that work for what I want to do.
Al

 

[Al Delgado]

I implemented this, is there a way to format so, that entries that are not 5 or 4 will just show the number, 1,2,3?

[=5]#" Ex";[=4]#" VG";

 

[NARAYANK991]

Hi Al ,

Just add the # symbol after your existing format string , thus :

[=5]#" Ex";[=4]#" VG";#

Narayan

 

[Al Delgado]

Thank you for the help Narayan!