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) यदि B1: B4 में होंगे - 20000, 4000, 12000, 8000 जबकि C1: C4 में होंगे "=DATE( 2000; 1; 1)", "=DATE( 2000; 6; 1)", "=DATE( 2000; 12; 30)", "=DATE( 2001; 3; 1)" तो परिणाम होगा 0. 2115964