Priority Formula help

[English Rob]

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

 

[Eric W]

Try:

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

 

[Fluff]

One option
=IF(B13<8,"Low",IF(B13<15,"Medium","High"))

 

[English Rob]

That easy .. you are the man, thank you so much.

 

[English Rob]

That easy .. you are the man, thank you so much.

Eric W

Thank you also Fluff.

 

[Eric W]

Glad we could help.