|
|
#3
05-13-2014, 10:56 PM
|
|||
|
|||
Thanks. That is brilliant.
I now feed in the "Order" of the cash movements within each investment: 1, 2, 3 etc This generates the offsets that you need for your formula = 1 - Order = 0, -1, -2, etc For some unknown reason this also fixed a problem I was having with XIRR XIRR had been refusing to give negative internal rates of return. Now it is fine. Thanks Problem solved. 
|
| Tags |
| excel 2007, names, range |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 How to define restrictions to resource combination
|
andrebmsilva | Project | 6 | 11-10-2013 03:02 PM |
| Referencing a named (calculated) range on a remote spreadsheet | TishyMouse | Excel | 1 | 04-25-2012 08:45 AM |
|
Excel - move with tab through named range
|
mjlaw | Excel | 4 | 03-26-2012 10:40 AM |
|
Named range drop-down
|
jgelpi16 | Excel | 1 | 04-08-2011 03:08 PM |
|
Is there a way to Define a common Table Format as Object?
|
blackduck603 | Word Tables | 1 | 02-20-2009 03:25 PM |
Windows 7 
Office 2007
Threaded Mode