Re: [sc-dev] Issue 88967: PROB, FORECAST functions: scalar evaluation of array parameter

2008-06-26 Thread Eike Rathke
Hi David, On Wednesday, 2008-06-25 20:55:12 +0100, David King wrote: Say we have A1:C1 = {7|6|5} In cell A2 we enter, as an array formula: =PROB({5;6;7};{0.2;0.3;0.5};A1:C1) and, correctly, A2:C2 = {0.5|0.3|0.2}. Now in cell D4 we enter, as a normal (non-array) formula:

[sc-dev] Issue 88967: PROB, FORECAST functions: scalar evaluation of array parameter

2008-06-25 Thread David King
Hi Eike Following up here on your response to this issue. Thanks for looking at it. Say we have A1:C1 = {7|6|5} In cell A2 we enter, as an array formula: =PROB({5;6;7};{0.2;0.3;0.5};A1:C1) and, correctly, A2:C2 = {0.5|0.3|0.2}. Now in cell D4 we enter, as a normal (non-array) formula: