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:
=PROB({5;6;7};{0.2;0.3;0.5};A1:C1)
I hold that the relevant part of ODFF is:
"3.2 Non-Scalar Evaluation (aka 'Array expressions')
<snip>
1)Normal evaluation in non-'array' mode does an implicit
intersection of the argument with the expression's evaluation
position.
<snip>
1.1)References
If the target reference is a row-vector (Nx1) use the value at
the intersection of the evaluation position's column and the
reference's row.
in cell B2 : =ABS(A1:C1) => ABS(B1)
if there is no intersection the result is #VALUE!
in cell B4 : =ABS(A1:C1) => #VALUE!"
OK, clearly there's an error in this ODFF draft, because B4
intersects A1:C1 at cell B1. Let's say it should read
"in cell D4 : =ABS(A1:C1) => #VALUE!"
So my view is that within PROB we should be looking for that same
intersection of A1:C1 with D4, which doesn't exist, so the result
should be #VALUE!
The fact that the other parameters are 'ForceArray' doesn't
matter, does it?
"6.2.3 Force to array context (ForceArray)
Some functions' parameters have a ForceArray attribute, which
forces calculation of the argument's expression into non-scalar
array mode."
So this only acts on the ForceArray parameter/argument itself.
I'd be delighted for you to educate me if I'm wrong ;)
David
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
