What Formula Do I Use To Show A Calculation % For A Range If Result Is BETWEEN Certain Values?

I attached a sheet with an example. What I want is a staggered range in Column D that shows a certain percentage based on the previous columns result:   If "% Increase In Value" (Column C) is in t...