if else statement for 2 cells rows

[nerdyplayer]

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 A	Column B	results
102	76	passing
143	95	failing
110	85	passing
156	87	failing

The criteria is

Column A <140 AND column B <90 pass 

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

[#2 · Accepted solution]

@nerdyplayer Try this:

=IF(AND(A1<140,B1<90),"Pass","Fail")