The information in this article applies to:
SUMMARY
In Microsoft Excel, if a COMMAND+ENTERed array formula contains
certain macro action-invoking functions, for example, GOTO or RETURN,
the functions are not executed.
MORE INFORMATION
For example, when the following array formula is COMMAND+ENTERed, it
returns the average of all the numbers in the range A1:A10 that are
greater than 5:
To use this result in a conditional branching statement later in the macro, refer to this cell. For example, if you want to branch the operation to cell B1 if this average is greater than 20, use the following statement, where "ref" is the reference to the cell containing the AVERAGE formula: =IF(ref>20,GOTO(B1)) Additional query words: 1.0 1.00 1.03 1.04 1.06 1.5 1.50 2.20 3.0 4.00
Keywords : |
Last Reviewed: March 15, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |