Programming Conditional Formulas

I have a set of numbers, and if a number falls within a certain range, the cell I'm programming needs to multiply the corresponding number by 28, and then be multiplied by the corresponding percentage according to where in the range it fell. Here's the chart:

0-834 multiply by 77.4%
835-865 multiply by 76.9%
866-897 multiply by 76.5%
898-929 multiply by 76.4%
etc. etc. etc. for about fifty lines

There are 47 different ranges that the number can fall into, so it'll be a rather large formula. So basically if the number is 855, it would first need to be multiplied by 28, and then multiplied by .769. If someone can get me started I'm sure I could fill in the blanks. Thanks for your help!!!

That's definitely the direction I should head, but I'm really not familiar with the vlookup feature. I definitely should get more comfortable with that! Thanks!!!

I think the formula you posted had the number multiplied by 28 before it was looked up in the chart. How would you multiply it AFTER the number is looked up? That's why the numbers are off I suppose.

Here's what I've got so far...I can't figure out what I'm doing wrong...1767Budget.xlsx

Thank you SOOOOO MUCH!!!!!!!! PERFECT!!!!!