Formula pull factor from chart based on value of diff field?

G

Guest

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?
 
G

Guest

Thanks Ann. I will have to study it to determine the exact formula to use. I
need to pull the term from another field and then, based on the term pull the
factor from the other sheet which is formatted like this:

Term in Months Prima Facie Rate per $100
1 0.29000
2 0.57000
3 0.86000
4 1.03000
5 1.20000
6 1.37000
7 1.52000
8 1.67000
9 1.82000
10 1.95000
11 2.07000
12 2.20000
13 2.27000
14 2.33000
15 2.40000
16 2.47000

Any suggestions?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup, What is correct formula for problem below? 7
Do I use "IF" or something else? 10
Return a value from Chart 1 depending on the value typed into char 1
Extracting cells from worksheet based on value of 2 cells 1
Formula Based on Multiple Sheets 5
CREATING FORMULA IN ONE WORKSHEET BASED ON MULTIPLE CRITERIA IN AN 2
Excel Drag autofill only part of formula 3
How to populate a cell with numeric value based on textselected from pull down in adjacent cell? 1

Top