Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
clock | Excel Worksheet Functions | |||
Using function results as parameters in another function | Excel Worksheet Functions | |||
XIRR function on Excel 2003 | Excel Worksheet Functions | |||
Function Parameters | Setting up and Configuration of Excel | |||
XIRR Function Error | Excel Worksheet Functions |