Microsoft KB Archive/46505

From BetaArchive Wiki
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

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