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?

Try this:

=CHOOSE(MAX(MATCH(A2,{0,140,160},1),MATCH(B2,{0,90,100},1)),"Controlled","Stage 1", "Stage 2")

Regards

A comparison of the various approaches is attached.

Regards

Always create a new thread, don't post in other peoples old threads. You can link to the old thread.

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread

@Jacc/Ali: to be fair, he is not asking a question, simply adding a late response to an old thread on the basis that it might help others who find this thread.

If he were to start a new thread, it would perhaps be more of a hint/tip rather than a question.

That said, my initial reaction was the same as yours until I read the contents.

Oops - my mistake - you are correct, Pete.

I think my brain reads no more than 3 words in a post and then extrapolates from that... Sorry

@Ali: Pete?

@Jacc: no worries, I nearly went down the same track

I was able to open the files without any problem.

Thanks for the feedback