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?

Do you need a vlookup, Bill?
http://www.officearticles.com/excel/...soft_excel.htm
*******************
~Anne Troy

www.OfficeArticles.com


"Bill R" <Bill wrote in message
...
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?

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?

"Anne Troy" wrote:

Do you need a vlookup, Bill?
http://www.officearticles.com/excel/...soft_excel.htm
*******************
~Anne Troy

www.OfficeArticles.com


"Bill R" <Bill wrote in message
...
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?

Try this, Bill: http://www.officearticles.com/downloads/billr.zip
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com




"Bill R" wrote in message
...
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?

"Anne Troy" wrote:

Do you need a vlookup, Bill?

http://www.officearticles.com/excel/...soft_excel.htm
*******************
~Anne Troy

www.OfficeArticles.com


"Bill R" <Bill wrote in message
...
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?