Need help with my Formula ....Trying to figure out a Formula where two values have to be less than or equal to 130/80...

[tradich]

Hi,

I'm trying to figure out a formula where someone has to meet BOTH values for Blood Pressure of 130/85.
1= met and 0 = not met
(both systolic and diastolic need to be met to earn)

So, If the BP of 125/80 they earn a 1 and if it's 130/90, they get a 0.

My formula is below but cannot figure out what I'm missing.... (O is diastolic and P is Systolic)

=IF(AND(O2<130,P2<85),1,0)

Thank you!!

 

[philwojo]

At first glance it looks good, what results are you getting that are wrong?

 

[Dave Patton]

try either of

=IF(AND(O2<=130,P2<=85),1,0)

=AND(O2<=130,P2<=85)+0