Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Let's say I have a schedule of cash flows and dates that I want to make
calculations of the internal rate of return. But I don't have the data organized in a way that lets me specify the cell range of the values or the cell range of the dates. Instead I need to explicitly name individual cells in the series. Is there a way for me to do this in the XIRR function? If not, what is a better alternative to XIRR that lets me name discrete cells for values and dates in the time series? -- W |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Cell values to an array, then array transpose to another workbook | Excel Programming | |||
Can XIRR Work on Dates That Move Backwards in Time? | Excel Worksheet Functions | |||
Using XIRR in an array formula | Excel Worksheet Functions | |||
Array: Counting multiple values within array | Excel Worksheet Functions | |||
search an array for values contained in another array | Excel Programming |