XNPV( 5%; B1: B4; C1: C4) suposa que B1: B4 conté - 20000, 4000, 12000, 8000 mentre que C1: C4 conté "=DATE( 2000; 1; 1)", "=DATE( 2000; 6; 1)", "=DATE( 2000; 12; 30)", "=DATE( 2001; 3; 1)" retorna 2907. 83187
XNPV(5%; 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 2907.83187