title: Same formula different behaviour
body: <p>I have a Google Sheet with a formula that calulates a price based on different data provided by a Google Form. If I use arrayformula (my formula) in some cases I have a wrong calculation, while if I type the formula directly in the cell I receive the right output.</p>
  
  <p>I've solved the issue by removing the arrayformula, but I wonder if there might be a different solution</p>
  
  <p>This sometimes fails:</p>
  
  <pre><code>=arrayformula(SE(X2:X = "SI";SE(AB2:AB = "SI"; SE(E(Z2:Z = "SI"; Y2:Y = "NO");15;40); 50); SE(AC2:AC = "SI"; SE(AE2:AE ="SI"; SE(E(Z2:Z = "SI"; Y2:Y ="NO");10;25); 35); 50)))
  </code></pre>
  
  <p>This is working:</p>
  
  <pre><code>=SE(NON(VAL.VUOTO(X9));SE(X9:X = "SI";SE(AB9 = "SI"; SE(E(Z9 = "SI";      Y9:Y = "NO");15;40); 50); SE(AC9 = "SI"; SE(AE9 ="SI"; SE(E(Z9 = "SI"; Y9 = "NO");10;25); 35); 50));)
  </code></pre>
  
  <p>Text is in Italian, the keywords are: </p>
  
  <pre><code>SE = IF
  E = AND
  NON = NOT
  VAL.VUOTO = ISBLANK
  </code></pre>