Convert number range to text e.g. 1-3 = "Low"

**jaywizz** · 07-18-2016, 08:37 PM

Folks I am trying to convert a range of numbers that are displayed in a column into a word e.g.:

1, 2, 3 = Low
4, 5, 6 = Medium
7, 8, 9 = High

Any ideas?

**Tony Valko** · 07-18-2016, 08:51 PM

Do you have to account for numbers <1 and/or >9?

**Tony Valko** · 07-18-2016, 09:06 PM

Originally Posted by Tony Valko

Do you have to account for numbers <1 and/or >9?

Assuming not...

Try one of these...

=IF(A1>=7,"High",IF(A1>=4,"Medium",IF(A1>=1,"Low","")))

=IFERROR(LOOKUP(A1,{1,4,7},{"Low","Medium","High"}),"")

**AlKey** · 07-18-2016, 11:02 PM

Or try this
Enter formula in B1 and copy down

Formula:

Please Login or Register  to view this content.

v	A	B
1	3	Low
2	1	Low
3	5	Medium
4	8	High
5	6	Medium
6	9	High
7	8	High
8

Convert number range to text e.g. 1-3 = "Low"

LinkBack

Thread Tools

Rate This Thread

Display

Convert number range to text e.g. 1-3 = "Low"

Re: Convert number range to text e.g. 1-3 = "Low"

Re: Convert number range to text e.g. 1-3 = "Low"

Re: Convert number range to text e.g. 1-3 = "Low"

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Convert Long Part Number List to "Text" Format??

[SOLVED] Range("A1") = Sheets("Sheet2").CenterHeader.Text doesnt work.

Find "TEXT 1" in a range and enter "TEXT 2" in the adjacent cell

[SOLVED] Re: macro for converting number stored as "text" (or preceeded with ') to "number" formatting

macro for converting number stored as "text" (or preceeded with ') to "number" formatting

Why does excel convert my text "6990011011234" to "6.99E+12"?

convert a number in Excel from numeric to text, i.e. "1" to "one"

Bookmarks

Bookmarks

Posting Permissions