ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   XIRR function input parameters (https://www.excelbanter.com/excel-worksheet-functions/24144-xirr-function-input-parameters.html)

kieran sweeney

XIRR function input parameters
 
I use the XIRR function regularly but would like to input relative referneces
instead of always using arrays or constants (as in the Help example) but if I
try this I get an error.
Specifically I would like to do something like this: xirr({-a1,a2},{b1,b2}).
This way I can calculate the period return from a list of positive values
(e.g. balances as of a certain date).
Thanks,

Kieran


All times are GMT +1. The time now is 02:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com