Microsoft KB Archive/46505

From BetaArchive Wiki

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


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:


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.