Microsoft KB Archive/46505

{|
 * width="100%"|

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 :