XIRR( B1: B4; C1: C4) Suposem que B1: B4 contenen - 20000, 4000, 12000, 8000 mentre que C1: C4 contenen "=DATE( 2000; 1; 1)", "=DATE( 2000; 6; 1)", "=DATE( 2000; 12; 30)", "=DATE( 2001; 3; 1)" retorna 0. 2115964
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