Morning all,

Im after some help for an assignment im doing.
While it may not be the most effective way to work it out, it's what i'm required to do.

I have to calculate interest on a loan amount where the interest rate varies between each level of $$ borrowed. Similar to how tax is calculated.

I have done this for my nested if statement, but the second question is how to do it using a vlookup.
My tutor told me I will be using if statements inside it.

$0-$12,000 borrowed is 5%. $12,001-$45,000 is 7.5%, $45,000-$80,000 is 8% and above $80,000 is 8.5%

My if statement is as follows: Referencing back to Cell B8

=IF(B8<12000,B8*0.05,IF(B8<45000,(B8-12000)*0.075+(12000*0.05),IF(B8<80000,((B8-45000)*0.08)+((45000-12000)*0.075)+(12000*0.05),IF(B8>=80000,((B8-80000)*0.085)+((80000-45000)*0.08)+((45000-12000)*0.075)+(12000*0.05),0))))

This works very well.

But how on earth do i get this into a table with only the % showing?

Thanks in advance for any help.
(I am also interested in the best way to do this for future referance too)