Excel: Using Discontinuous Ranges in a Function |
The information in this article applies to:
- Microsoft Excel for the Macintosh, versions 1.x, 2.2, 3.0, 4.0
SUMMARY
To use discontinuous ranges in Microsoft Excel functions, you must enter the range in parentheses. For example, a discontinuous range in the IRR() function appears as follows:
=IRR(($A$1:$A$4,$A$7,$A$9:$A$15),10%)
Additional query words: discontiguous noncontiguous noncontinuous connected
Keywords :
Version :
Platform :
Issue type :
Technology :
Last Reviewed: March 15, 1999 |