Skip to main content

Diigo Home

Microsoft office online forum h.c. chen's excel Q&A - The Diigo Meta page

www.microsoft.com/...default.mspx - Cached - Annotated View

H.C. Chen's personal annotations on this page

hcchen
Hcchen bookmarked on 2009-05-03 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.

  • 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.

This link has been bookmarked by 1 people . It was first bookmarked on 03 May 2009, by H.C. Chen.

  • 03 May 09
    hcchen
    H.C. Chen

    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.

    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.

Top Tags