I have tried several ways and cannot get this to work. My problem is this:

when doing nested if D11=344,895, D12=895,202, and D13=976,281. Now I need
my nested if to work so if D11 is 900,000 it's 4%, if600,000 its 2%, and if
its <600,000 its 1%. Everytime i do this, or try I should say, it comes up
something different everytime. I would really like to be able to use a
VLOOKUP but How do you get it to understand that if the cell is 900,000 its
4%? I did my table (K6)900,000 which L6 is 4%; (K7)600,00 which L7 is 2%
and so on. I just named my table Percentage_Paid. No matter what I try either
Nested IF or a VLOOKUP I get errors. Can somebody help? Hopefully I made
sense. Thank you in advance.
Rhonda