title: How to define an array that contains formulas in Excel
body: <p>ideally I would like a solution that does not imply using VBA, but if that is the only way you know go ahead.</p>
  <p>Does it exist any way of creating or emulating an array in excel that contains formulas instead of being static?</p>
  <p>I know you can create a 1x2 array of constant values with <code>={10,20}</code>. But what I need instead is to be able to create a 1x2 array of formulas something like <code>={10*A1,20*A2}</code>. Actually the formula that I need to use in the array isn't a multiplication but a <code>=Forecast.Linear(x,Ys,Xs)</code>.</p>
  <p>It needs to be a 1x2 array because this part will be a parameter of another larger formula (another forecast.linear).</p>