| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formula pull factor from chart based on value of diff field?
I have a workbook, in Excel, that has a credit disability insurance
calculator in it that calculates the premium based on the term and amount financed. I already have the term pulling from another sheet within the workbook but I don't know what formula to use to pull the correct factor (based on the term) from another worksheet within the workbook. There are 85 different factors that can be used depending on the term of the loan. Can someone help me? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for next day based on clock | Excel Worksheet Functions | |||
| Formula to compare multiple rows values based on another column? | Excel Worksheet Functions | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
| Help: Contingency based fee formula / cashflow analysis | Excel Discussion (Misc queries) | |||
| create a chart with a formula | Charts and Charting in Excel | |||
Threaded Mode
