H.C. Chen's Library tagged office → View Popular

Filter:
All
Annotated

03 May 09

Microsoft office online forum h.c. chen's excel Q&A

As written the formula returns a 3x1 array comprised of the range B5:B7.
Since the formula wasn't array entered the formula in J4 returns the #VALUE!
error. Now, here's where the implicit intersection rule comes into play. The
formula in J5 is on the same row as B5 which is the first element in the
height argument array returned by the formula. The formula in J6 is on the
same row as B6 which is the second element in the height argument array
returned by the formula. The formula in J4 refers to B5 but since the
formula was not array entered and is not on the same row as B5 (not within
the implicit intersection) the result is an error.

www.microsoft.com/...default.mspx - Preview

microsoft forum online help office excel group

As written the formula returns a 3x1 array comprised of the range B5:B7.

Since the formula wasn't array entered the formula in J4 returns the #VALUE!

error. Now, here's where the implicit intersection rule comes into play. The

formula in J5 is on the same row as B5 which is the first element in the

height argument array returned by the formula. The formula in J6 is on the

same row as B6 which is the second element in the height argument array

returned by the formula. The formula in J4 refers to B5 but since the

formula was not array entered and is not on the same row as B5 (not within

the implicit intersection) the result is an error.