IF AND OR THEN ???

LisaMarie1981 

But...When I try to change the amount in B11 to 500,000 and B12 to Bad it should be 480,000 but it's coming up as 485,000, and if I change it to Good it should be 510,000 not 507,50

This is a matter of where the line is drawn. And that becomes, quite literally, a matter of pennies.

For example, if you change D2 to 501,000 then you get the result you're looking for for $500,000. For that matter, you can change D2 to 500,000.01 and get the results you're looking for. I suggest you add one penny to each of those top line numbers.  By the way, this does not work for B11 entries below 100K. I have been assuming that's your lowest boundary, but if that's not the case, you can just lower that number in B2, unless you'd want different factors for ranges below 100K. 

I need the last part to be anything above E2 which doesn't seem to pull (ie. if I change B11 to 800,000 it doesn't pull from column E)

Not sure what you're talking about. Using the spreadsheet OliverScheurich created, and entering 800,000 I get the following.

The other thing for you to do here is to play around with this so that you understand how it's working and can maintain it yourself. You should feel free to change those numbers in row 2, for example, to see how that affects things. You can also change the percentages in rows 3-5.....one of the nice things about the formulas you've gotten is that the values are NOT hard-coded into the formulas (as they were with the IF and IFS formulas).......so you don't need to change the formula to update the calculations.