Excel: Using Discontinuous Ranges in a Function

ID: Q46505

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        :

Last Reviewed: March 15, 1999