XIRR(B1: B4; C1: C4) Suppose B1: B4 contains -20000, 4000, 12000, 8000 while C1: C4 contains "=DATE(2000; 1; 1)", "=DATE(2000; 6; 1)", "=DATE(2000; 12; 30)", "=DATE(2001; 3; 1)" returns 0.2115964
XIRR( B1: B4; C1: C4) Supóñase que B1: B4 contén - 20000, 4000, 12000, 8000 namentres que C1: C4 contén "=DATE( 2000; 1; 1)", "=DATE( 2000; 6; 1)", "=DATE( 2000; 12; 30)", "=DATE( 2001; 3; 1)" pois isto devolve 0. 2115964