Skip to main content

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

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.
1 - 16 of 16
Showing 20▼ items per page

Selected Tags

Related Tags

Sponsored Links

Ads by Google

Highlighter, Sticky notes, Tagging, Groups and Network: integrated suite dramatically boosting research productivity. Learn more »

Join Diigo