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
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.