Check if cell contains a number in a given range of numbers

[smockpuv]

I'm trying to build out a formula to return a letter based on a tree of possible answers from different columns. I've attached an image of the table I'm trying to build the equation for. Basically if column A contains a 9 or a 10 and if column B contains 10, 9, or 8 and column C contains 10, 9, 8, ...1, then return an H, else, check back in column A and continue on. I'm not sure how to simplify the equation so I'm not doing a million IF(OR()) statements.
Screenshot at May 26 14-12-38.png

[janmorris]

is there any chance that you can create a mockup file that has some sample data that helpers can use to start building your formulas?

[smockpuv]

Not sure why it's not processing the equation, but this is what I've been doing as a workaround for now. A ton of if(or() statements.
I think I've attached the file, let's see if this works.

[janmorris]

at the moment, the formula doesnt match what is displayed in the image, and there is not enough sample data with which to decipher what your conditions are.

i suggest you write the list of conditions (not the formula), so that we can understand what result you are trying to achieve.

[smockpuv]

If severity is a 9 or 10, and occurrence is 10, 9, or 8, and detection is 10, 9, 8, 7, 6, 5, 4, 3, 2, or 1 return "H". Else, if occurrence is 7 or 6, and detection is 10, 9, 8, 7, 6, 5, 4, 3, 2, or 1 return "H". Else, if occurrence is 5 or 4 and detection is 10, 9, 8, 7, 6, 5, 4, 3, or 2, return "H". Else, if detection is 1, return "M". Else, if occurrence is 3 or 2 and detection is 10, 9, 8, or 7 return "H". Else, if detection is 6 or 5 return "M". Else if detection is 4, 3, 2, or 1 return "L".

So I'm essentially trying to build the logic that will automatically calculate the Action Priority (AP) column and assign a value of High (H), Medium (M), or Low (L) based on the values in the severity, occurrence and detection columns. Does that help or just complicate matters more?

[JeteMc]

As there appear to be more L's and M's than H's I would isolate the L and M conditions for those AP's and let everything else yield H as in:

Please Login or Register  to view this content.

Take a look at Sheet2 to see if all the results look correct.
Let us know if you have any questions.