Formula that changes answer cell based on numeric value in reference cell

Hey all,

I'm not the most experienced with excel, but have been elected the office "computer guy". I'm trying to create a worksheet where we plug in three numbers and everything else is handled by formulas for calculating pricing on a product we make in our office.

I am running into trouble when I have D8 reference C8 for a numeric value, then show the proper price based off of a scale (eg. 1-99 = $.16, 100-999 = $.14, 1000-3999 = $.12 etc.) Where C8's number decides the price shown in D8.

I'm doing something similar in H8 based off of the numbers in A8 and B8 as well, but that may take us a while longer to come up with.

I've really only used =sum type formulas before, and I feel like an =if formula would work, but I'm having trouble writing one with multiple answers.

Thanks for the help in advance!

Tinman