# Different values depending on whether in or out of an arrayformula

**URL:** <https://community.glideapps.com/t/different-values-depending-on-whether-in-or-out-of-an-arrayformula/1096>\
**Category:** Ask for Help\
**Created:** [October 11, 2019, 2:56pm UTC](https://community.glideapps.com/t/different-values-depending-on-whether-in-or-out-of-an-arrayformula/1096 "2019-10-11T14:56:09Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sandro\_Brito](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sandro_brito/32/552_2.png) [@Sandro\_Brito](https://community.glideapps.com/u/Sandro_Brito)\
**Post date:** [October 11, 2019, 2:56pm UTC](https://community.glideapps.com/t/different-values-depending-on-whether-in-or-out-of-an-arrayformula/1096/1 "2019-10-11T14:56:09Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [October 11, 2019, 3:24pm UTC](https://community.glideapps.com/t/different-values-depending-on-whether-in-or-out-of-an-arrayformula/1096/2 "2019-10-11T15:24:22Z")

</div>

Try removing all of the dollar signs. The purpose of the dollar signs is to prevent the column values from increment when dragging a formula down multiple cells. Shouldn’t be necessary when using an arrayformula.