Hi all I need to return a True in the result column if TRUE exists in either record 1 2 or 3.
Have tried If =AND etc.
Thanks
>Solution :
Try using the following formula :
=BYROW(A2:C5,LAMBDA(α,OR(α)))
Using ETA LAMBDA() it is relatively shorter as well:
=BYROW(A2:C5,OR)
Or, Simply use OR() function and fill down:
=OR(A2:C2)

