I am working a on a blood pressure spreadsheet.I have 2 rows of numbers, and i am trying to figure out how to quickly show which set of results will pass the criteria.Column AColumn Bresults10276passing14395failing11085passing15687failing The criteria isColumn A <140 AND column B <90 pass IF(resultsA <140,and (if(Result B<90), "pass", failed))

nerdyplayer Try this:=IF(AND(A1<140,B1<90),"Pass","Fail")

Forum Discussion

Copper Contributor

Sep 12, 2022

Solved

I am working a on a blood pressure spreadsheet.

I have 2 rows of numbers, and i am trying to figure out how to quickly show which set of results will pass the criteria.

The criteria is

Column A <140 AND column B <90 pass

IF(resultsA <140,and (if(Result B<90), "pass", failed))

Riny_van_Eekelen
Sep 12, 2022
nerdyplayer Try this:
=IF(AND(A1<140,B1<90),"Pass","Fail")

Riny_van_Eekelen
Platinum Contributor
Sep 12, 2022
nerdyplayer Try this:
=IF(AND(A1<140,B1<90),"Pass","Fail")