| Line 58: |
Line 58: |
| | | 10000 || 4/3/2013 | | | 10000 || 4/3/2013 |
| | |} | | |} |
| − | XIRR(A1:A5,B1:B5,0,0.1)=0.43578123326 | + | #=XIRR(A1:A5,B1:B5,0,0.1)=0.43578123326 |
| − | XIRR(A1:A5,B1:B5,0,0,2) = 0.43572667130 | + | #=XIRR(A1:A5,B1:B5,0,0,2) = 0.43572667130 |
| − | XIRR(A1:A5,B1:B5,1,5,0) =0.18336350930 | + | #=XIRR(A1:A5,B1:B5,1,5,0) =0.18336350930 |
| | | | |
| | ==See Also== | | ==See Also== |