How to categorize blood pressure readings into groups

I am trying to automate a frequently performed process in our medical clinic. We often collect blood pressure reading and assign them to a level of severity. I would like to be able to have excel perform this function and hope someone cn help.

Let me explain a bit more. Every blood pressure has two numbers: a top # and a bottom #. Blood pressures are grouped into the following category

• Controlled if both numbers are less than 140/90
• Stage 1 - top number is between 140-159 or bottom number is 90-99
• Stage 2 - top number is equal or greater than 160 or bottom number is equal or greater than 100

If a blood pressure falls in more that one group, the blood pressure is assigned to the highest group. So the top group Stage 2> Stage1> controlled. For example 145/110 is stage 2 and a BP of 110/95 is stage 1

Can someone point me in the right direction?