Assign strings to numeric intervals

[matteo]

Hi guys,

I’m struggling with a simple issue. I have a numeric column (values from 0 to 365) and I want to assign specific letters to specific numeric ranges in another column, say:

• from 0 to 22 → N
• from 22 to 45 → A
• … and so on

I know I can do something like that with the Conditional formatting, but what I want to do is create another column and not edit the original one.

I know I can use the IF statement, but isn’t there a simple graphical way where to add the parameters for the new column?

Thanks!

[dajare]

So - does “22” get both an “N” and an “A”? or should the range be described differently?

[karolus]

Hallo

setup a 2Column-range with contents:

0    N
22   A
45   ?
...

and refer to that range with Formula:

=VLOOKUP( your_number ; the_range ; 2)