Need an excel formula in order to pick the interest rate.

Asked By Judith Lauren 60 points N/A Posted on - 07/28/2012

I have a Microsoft excel sheet including details of the loan providing to staff members of a company. These loans are recovered with an interest. These interest rates are variable with the loan value as follows.

Loan value                                                          Interest rate

Less than $ 10,000.00                     –              2%

$10,000.00-$25,000.00                    –              3%

More than $25, 0000.00                   –              4%

I want an excel formula which interest rate to be appeared according to the loan value based on the above conditions?

Can anybody help me?

• Status: Open
• Question Views: 1054
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Geisha Nitta

Go To Solution

Best Answer

Best Answer

Answered By Geisha Nitta 0 points N/A #134059

Need an excel formula in order to pick the interest rate.

Yes, there are many functions in Microsoft excel which we can use to make easy our works. When considering your requirement we can use the “IF” function.

I will take an example according to the conditions that you mentioned in the question.

I assume what you want is the loan interest rate to be appeared in column C according to the loan amount by using the conditions mentioned.

Ok. We will use the “IF” function. Go to the cell C3 and type the following formula.

=IF(B3<10000,2%,IF(B3<25000,3%,IF(B3>25000,4%,"")))

Then copy that formula and paste in the below cells up to the loan amount that you have.

Now interest rates will be displayed as follows.

About Geisha Nitta

Questions
1

Answers
55

Best Answers
27

• Vote Up 0 Vote Down

• Posted on - 07/28/2012
• Question Category: MS Excel

Answered By Anthew Staw 0 points N/A #134060

Need an excel formula in order to pick the interest rate.

There are actually a lot of ways to do this. What I did is the “vlookup” formula wherein if you type a certain value of a cell it looks for the value in a specific table and then gives the value that you have inputted to the same cell. Also you can use “match” formula, “hlookup” formula and “if” formulas. It’s actually fun using excel when you get used to it.

Hope this helps.

About Anthew Staw

Questions
3

Answers
34

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 07/28/2012
• Question Category: MS Excel