Hello,
For some reason I am getting different values (a winner) depending on if the formula is inline with the values or if it’s in an arrayformula.
There’s only 1 row of values on the table.
Player 1 (B column) has played Rock
Player 2 (H column) has played Scissors
if this formula is inline the winner is B
=if(or(and($D$2:$D=“Rock”, $J$2:$J=“Scissors”), and($D$2:$D=“Scissors”, $J$2:$J=“Paper”), and($D$2:$D= “Paper”, $J$2:$J=“Rock”)), $B$2:$B&" won", $H$2:$H&" won")
If this formula is on cell T2 the winner is H
=ARRAYFORMULA(if(LEN($A$2:$A) = 0,“”,if($D$2:$D = $J$2:$J,“It’s a tie”, if(or(and($D$2:$D=“Rock”, $J$2:$J=“Scissors”), and($D$2:$D=“Scissors”, $J$2:$J=“Paper”), and($D$2:$D= “Paper”, $J$2:$J=“Rock”)), $B$2:$B&" won", $H$2:$H&" won"))))
Anyone can understand why?