title: Declare array of cells depending on value
body: <p>In Google Spreadsheet I am trying to declare an array of cells depending on the result of some operation. Switching the sign of the result I should create one, two or three elements of array (cells).</p>
  
  <p>The initial algorithm is like:
  <code>={SWITCH(SIGN(A1);-1;"1";0;"1;1";1;"1;1;1")}</code>
  It does not work of course but the idea is to get one element for minus, two elements for zero and three elements for plus.</p>
  
  <p>Have you got any ideas?</p>