I'm creating a tiered pricing structure that changes based on the number in a certain cell.

Basically - here it is 0-25K = .05, 25K-100K = .03, >100K = .01

The number has to fall within those ranges to get the correct amount.

How do I do this in a quick efficient way without having to do the IF statements and combinations? I can do that but it seems like the long way.

Thoughts?

Matt