# Priority Formula help

#### English Rob

##### New Member
Hello All,

I am trying to create a survey that results in a priority. Here's the detail.

I have 10 questions, each answer is to be entered as a number (0 = no, 1 = not sure/maybe and 2 = yes)
After answering them all, I have the total in a cell, lets call it B13, which will be anything from 0 to 20.

Here's what I am struggling with. I want a single cell, let's say B14, to display either "Low", "Medium" or "High" based on the score in B13,
so a score of 0-7 = Low, 8 to 14 = Medium and 15 to 20 = high.

I can achieve this but only using 20 cells and IF rules etc. I want it in a single cell not 20.

Cany anyone help?

Thanks - Rob

### Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

#### Eric W

##### MrExcel MVP
Try:

=LOOKUP(B13,{0,8,15},{"Low","Medium","High"})

#### Fluff

##### MrExcel MVP, Moderator
One option
=IF(B13<8,"Low",IF(B13<15,"Medium","High"))

#### English Rob

##### New Member
That easy .. you are the man, thank you so much.

#### English Rob

##### New Member
That easy .. you are the man, thank you so much.
Eric W

Thank you also Fluff.

#### Eric W

##### MrExcel MVP
Glad we could help.

Replies
0
Views
163
Replies
3
Views
195
Replies
2
Views
140
Replies
1
Views
145
Replies
7
Views
182

1,171,625
Messages
5,876,518
Members
433,197
Latest member

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back