Forum Discussion
nerdyplayer
Sep 12, 2022Copper Contributor
if else statement for 2 cells rows
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 resul...
- Sep 12, 2022
nerdyplayer Try this:
=IF(AND(A1<140,B1<90),"Pass","Fail")
Riny_van_Eekelen
Sep 12, 2022Platinum Contributor
nerdyplayer Try this:
=IF(AND(A1<140,B1<90),"Pass","Fail")