=If(and(L2=0,N2=0,P2=0),"No","Yes")
=Map(L2:L4,N2:N4,P2:P4,lambda(x,y,z,If(and(x=0,y=0,z=0),"No","Yes")))
We do not know what is possible with the OP's data, but that latest formula would fail with 2,3,-5Please ignore previous post; I reversed the requirement.
Cell Formulas | ||
---|---|---|
Range | Formula | |
U2:U5 | U2 | =IF(-MAP(L2:L5,N2:N5,P2:P5,CONCAT),"Yes","No") |
T2:T5 | T2 | =IF(-(L2&N2&P2),"Yes","No") |
Dynamic array formulas. |