Blood Pressure Formula

Can someone please help me with my formula? You can see logic in the diagram image I included in the XLSX, but my formula in E2 doesn't seem to work properly. Thanks for the help.

For example, if I set the SYS to 139 and DIA to 119, it shouldn't be Stage 1, it should be Stage 2 since the DIA is higher than 90 (but less than 120).

Try this:
=IF(OR(AND(C2>129,C2<140),AND(D2>79,D2<90)),"High BP Stage1",IF(OR(C2>139,D2>89),"High BP Stage2",IF(OR(C2>179,D2>119),"Hytertensive Crisis",IF(AND(C2<120,D2<80),"Normal",IF(AND(AND(C2>119,C2<130),D2>79,D2<80),"Elevated")))))


Bharath

Originally Posted by bsrivatsa

Try this:
=IF(OR(AND(C2>129,C2<140),AND(D2>79,D2<90)),"High BP Stage1",IF(OR(C2>139,D2>89),"High BP Stage2",IF(OR(C2>179,D2>119),"Hytertensive Crisis",IF(AND(C2<120,D2<80),"Normal",IF(AND(AND(C2>119,C2<130),D2>79,D2<80),"Elevated")))))


Bharath

If I do 120 SYS and 79 DIA, I get FALSE. I think I would need to remove "D2>79," to fix that issue.
=IF(OR(AND(C2>129,C2<140),AND(D2>79,D2<90)),"High BP Stage1",IF(OR(C2>139,D2>89),"High BP Stage2",IF(OR(C2>179,D2>119),"Hytertensive Crisis",IF(AND(C2<120,D2<80),"Normal",IF(AND(AND(C2>119,C2<130),D2<80),"Elevated")))))

However, if it is then set to 130 SYS and 90 DIA, it does not read Stage 2 and instead reads Stage 1. In other words, it should always take the more severe stage.

No one???? :-(

Originally Posted by excel_Noob1234

If I do 120 SYS and 79 DIA, I get FALSE. I think I would need to remove "D2>79," to fix that issue.
=IF(OR(AND(C2>129,C2<140),AND(D2>79,D2<90)),"High BP Stage1",IF(OR(C2>139,D2>89),"High BP Stage2",IF(OR(C2>179,D2>119),"Hytertensive Crisis",IF(AND(C2<120,D2<80),"Normal",IF(AND(AND(C2>119,C2<130),D2<80),"Elevated")))))

However, if it is then set to 130 SYS and 90 DIA, it does not read Stage 2 and instead reads Stage 1. In other words, it should always take the more severe stage.

Ok, try this-

=IF(OR(C2="",D2=""),"Enter Value",IF(AND(C2<>"",D2<>"",C2<120,D2<80),"Normal",IF(AND(AND(C2>119,C2<130),D2<80),"Elevated",IF(AND(AND(C2>129,C2<140),D2<89),"High BP stage 1",IF(AND(AND(D2>79,D2<90),C2<140),"High BP stage 1",IF(AND(AND(C2>139, C2<180),D2<120),"High BP stage 2",IF(AND(AND(D2>89,D2<120),C2<180),"High BP Stage 2",IF(AND(C2>180,D2>0),"Hypertensive crisis",IF(AND(D2>120,C2>0),"Hypertensive crisis")))))))))


Bharath

Originally Posted by Bo_Ry

Please try

=INDEX({"normal";"elevated";"High blood pressure Stage 1";"High blood pressure Stage 2";"Hypertensive Crisis"},MAX(MATCH(C2,{0,120,130,140,180}),MATCH(D2,{0,80,80,90,120})))

Amazing. This is so elegant!

That did the trick! Nice! Thank you.