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

B

Bill R

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

Bill R

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? 9
Problem with formula in Excel 3
How do I create the formula for this calculation? 1
Excel pull data based upon one specific word between two date 7
populate new "log" worksheet from invoice templates in other sheets 0
Extracting cells from worksheet based on value of 2 cells 1
Pull information based on a range of numbers 0

Top