| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
XIRR formula in non-normal struction
On Oct 10, 12:23 pm, Lary wrote:
How do you enter the XIRR formula when the numbers and dates are not in the normal column format structure. For example, the cash flow numbers are in cells A8,G8,K8 and the dates are in cells B8,H8,L8. Would the following form satisfy your requirements: =xirr((A8,G8,K8),(B8,H8,L8)) XIRR() seems to be one of the few functions that works with the union reference operator. See the "About calculation operators" help page. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula bar displays "=RC[-12]+RC[-11]". how to get normal view? | Excel Worksheet Functions | |||
| To XIRR or Not To XIRR | Excel Worksheet Functions | |||
| Normal Text in Formula | Excel Worksheet Functions | |||
| how do i make one part of my formula bold and the other normal? | Excel Worksheet Functions | |||
| XIRR and IRR | Excel Worksheet Functions | |||
Threaded Mode
