Could you write function for the following scenario?

[dener123]

Cell A	Cell B	Cell C	Cell D	Cell E
Row 1	2	2.2	2.5	(Need function for this cell)
Row 2	2.1	1.5	2.3
Row 3

I need a single function for the scenario:
If ALL values in Cell B, C, D in Row 1 are all Above or equal to 2, show "Yes" in Cell E, Row 1)
If At least 1 value in Cell B, C, D in Row 1 is below 2, show "No" in Cell E, Row 1)
If At least 1 value in Cell B, C, D in Row 1 is blank, show "No" in Cell E, Row 1)

 

[hagia_sofia]

Would this work for you:

=IFS(AND(B2:D2>=2),"Yes",OR(B3:D3<2,ISBLANK(B3:D3)),"No")

 

[Fluff]

Another option

=IF(COUNTIFS(B2:D2,">=2")=3,"Yes","No")

 

[RobP]

=IF(AND(B2>=2,C2>=2,D2>=2),"Yes",IF(OR(B2<2,C2<2,D2<2,B2="",C2="",D2=""),"No",""))

 

[dener123]

Would this work for you:

=IFS(AND(B2:D2>=2),"Yes",OR(B3:D3<2,ISBLANK(B3:D3)),"No")

Thank you! This works.
Could you do 1 more?

it's same scenario but one is changed.
Scenario:

If ALL values in Cell B, C, D in Row 1 are all Above or equal to 2, show "Yes" in Cell E, Row 1)
If ALL value in Cell B, C, D in Row 1 is below 2, show "No" in Cell E, Row 1)
If At least 1 value in Cell B, C, D in Row 1 is blank, show "No" in Cell E, Row 1)

 

[felixstraube]

One more:

=IF(SUM((B1:D1>=2)*1)=3, "yes", "no")

 

[hagia_sofia]

Thank you! This works.
Could you do 1 more?

it's same scenario but one is changed.
Scenario:

If ALL values in Cell B, C, D in Row 1 are all Above or equal to 2, show "Yes" in Cell E, Row 1)
If ALL value in Cell B, C, D in Row 1 is below 2, show "No" in Cell E, Row 1)
If At least 1 value in Cell B, C, D in Row 1 is blank, show "No" in Cell E, Row 1)

That wouls be:

=IFS(AND(B2:D2>=2),"Yes",AND(B2:D2<2),"No",OR(ISBLANK(B2:D2)),"No")

But what happens when e.g. two columns are < 2 and one > 2?

 

[Fluff]

Thank you! This works.

Are you sure? As that formula is looking at two different rows.

 

[Fluff]

If ALL values in Cell B, C, D in Row 1 are all Above or equal to 2, show "Yes" in Cell E, Row 1)
If ALL value in Cell B, C, D in Row 1 is below 2, show "No" in Cell E, Row 1)
If At least 1 value in Cell B, C, D in Row 1 is blank, show "No" in Cell E, Row 1)

Not sure what should happen if 1 or 2 values are >=2 & the other(s) are <2, but as you still want No if all 3 are are not >= 2 you can still use the formula in post#3.