Priority Formula help

English Rob

New Member
Joined
Apr 22, 2016
Messages
7
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
 

Some videos you may like

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
40,846
Office Version
365
Platform
Windows
One option
=IF(B13<8,"Low",IF(B13<15,"Medium","High"))
 

Watch MrExcel Video

Forum statistics

Threads
1,099,328
Messages
5,467,970
Members
406,561
Latest member
Grappledog

This Week's Hot Topics

Top