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

Asked By 60 points N/A Posted on -
qa-featured

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?

SHARE
Best Answer by Geisha Nitta
Best Answer
Best Answer
Answered By 0 points N/A #134059

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

qa-featured

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.

Using formula in Exccel

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%,"")))

Insert the formula

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.

Copy the the formula to following rows
Answered By 0 points N/A #134060

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

qa-featured

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.

Login/Register to Answer

Related Questions