XIRR with non-contiguous cells

English
, , , ,
#1

Can I use CALC’s XIRR with non-contiguous cells?

When I try I get a 504 error.

           (100.00)    01/01/20
(100.00)    105.00     01/03/20
            107.00     01/15/20
            110.00     02/25/20
		
		
	        0.42 	
	        Err:504

The formula in B7 is =XIRR(B1:B4,C1:C4,0.01)
The formula in B8 is =XIRR((A2,B2:B4),C1:C4,0.01)

Thanks

XIRR Sample.ods

(Edit: fixed PRE formatting -AK)

#2

Please upload a sample file (your data presented as text without showing any column and row headers are completely incomprehensible - at least for me)

#3

How does one upload a file? Thx

#4

Read this: Ask/Getting Started - The Document Foundation Wiki

#5

The sample is uploaded and seems to be available from my initial post.

However the answer seems to be that XIRR does not accept a range list/concatenation/union as argument.

So then the follow on is, is there a reasonable work around?

I would like to find something more elegant than creating multiple sheets with nearly the same data. Duplicate data can cause many problems - but there are some ugly ways that data can be manually duplicated so as to present a simple argument to XIRR.

Is there something better?

Thanks,

#6

XIRR does not accept a range list/concatenation/union as argument.

#7

Is there a work around? Thx

#8

Other than copying values to a contiguous range (or referencing cell ranges from there), no.

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.