| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Fund return v income
Trying to setup a historic income analysis. I have 10 funds giving quarterly
returns for the last 20 year. I'm inputting an initial investment and a fixed quarterly income. What I want is for the top performing fund to provide the income. I've already ranked the returns and worked the growth out but for the life of me I can't think how to get the formula to say if fund rank is 1 then remove income. If fund rank 1 is less than the income then fund rank 2 should be used....complex if formula? any thoughts? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to track mutual fund shares? | Excel Discussion (Misc queries) | |||
| How to calculate return on a open-ended mutual fund? | Excel Discussion (Misc queries) | |||
| Computing Mutual Fund Diversification | Excel Worksheet Functions | |||
| How to set up payout for prize fund? | Setting up and Configuration of Excel | |||
| formula for workbook showing daily income compared to goal income. | Excel Worksheet Functions | |||
Linear Mode
