| Line 22: |
Line 22: |
| | ==Examples== | | ==Examples== |
| | {| class="wikitable" | | {| class="wikitable" |
| − | |+1..10@SQRT
| |
| | |- | | |- |
| | ! !! A !! B | | ! !! A !! B |
| Line 48: |
Line 47: |
| | |} | | |} |
| | | | |
| − | #=IRR(A1:A6)=11.88% | + | #=IRR(A1:A6)=12.04% |
| − | #=IRR(A1:A5,20%) = -3.45% | + | #=IRR(A1:A5,20%) = 11.88% |
| − | #=IRR(B1:B7) = 6.7% | + | #=IRR(B1:B7) = 7.31%% |
| − | #=IRR(B1:B5,5%)= -160.99% | + | #=IRR(B1:B5,5%)= -12.47% |
| | | | |
| | ==See Also== | | ==See Also== |