If you include the actual array in the argument

If you include the actual array in the argument, you can designate the array by enclosing the values and dates

arguments inside braces. To show the preceding date MBT Chapa,values in an array, for example, you would type the

following:

{"1/1/2000","12/31/2000","4/15/2001","12/31/2001"}

To show the preceding cash flow values as an MBT Changa Cork,array, you would type the following:

{-1000,-1000,2000,1000}

If you enter the date values and cash flow values in worksheet ranges, you don’t need to worry about

identifying the date values and cash flow values as arrays. For example, if you enter the preceding set of date

values in the worksheet range A1:A4 and the preceding set of cash flow values in the worksheet range B1:B4, you

can use these worksheet ranges as the function arguments.

The XIRR and XNPV functions, predictably, require you to use date values that are valid. You must also use the

same number of date values as you use cash flow values. If you supply an invalid argument or set of arguments,

Excel returns the #NUM error value.

NOTE: Excel considers the first date value to be the starting date of the investment. Accordingly, the first

date value in your array or worksheet range must be the MBT Kimondo GTX earliest. Subsequent date values don't have to be in

chronological order, however.