Formula insert cost band

[max_max]

Hello to all,
In the attached file I must include this formula:

If the cost in E2 is in one of these bands:

Band 1 (less than 400 €)
Band 2 (from 400 € to less than 800 €)
Band 3 (from 800 € to less than 1200 €)
Band 4 (from 1200 € to less than € 1,500)
Band 5 (from 1500 € and beyond)

Put in H2 its band.

An example in E2 is 2800 €
In H2 must appear: Box 5 (from 1500 € and beyond)
I hope I was clear.
xam

 

[FormR]

Hi, here is one option:

="Box " & MATCH(E2,{0,400,800,1200,1500})

 

[max_max]

Hi formR,
it's o.k..
A change is possible.
I can not attach an example, I hope to explain.
Your formula now is this
= "Box" & match (F2; {0; 400; 800; 1200; 1500})
and the result is: box1 - box4 etc...
The editing is this:

instead box1 = (less than 400 €)
instead box2 =(from 400 € to less than 800 €)
instead box3 =(from 800 € to less than 1200 €)
instead box4 =(from 1200 € to less than € 1,500)
instead box5 = (from 1500 € and beyond)

max_max

 

[FormR]

The editing is this:

Hi, you can try:

=LOOKUP(E2,{0,400,800,1200,1500},{"(less than 400 €)","(from 400 € to less than 800 €)","(from 800 € to less than 1200 €)","(from 1200 € to less than € 1,500)","(from 1500 € and beyond)"})

 

[max_max]

Hi FormR,
the new formula it's o.k.
A greeting
max_max