SOLVED

if else statement for 2 cells rows

New Contributor

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 Bresults

102

76passing
14395

failing

11085passing
15687failing

 

The criteria is

Column A <140 AND column B <90 pass 

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

 

1 Reply
best response confirmed by nerdyplayer (New Contributor)
Solution

@nerdyplayer Try this:

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