Hey, thanks in advance for taking the time to read and possibly helping me solve this issue...

What I am doing is I am trying to create a formula that will make it simple for me to update a spreadsheet that has changing rankings of a set. Each rank has a value it receives based on a formula (so if it is ranked #1, it is 1*45000, if it is #2 it is .975*45000, and so on)

I would like to set a formula that will determine what the cell should be without having to link each cell to the correct formula (or number)

So, basically...I'm wondering if there is a way that you can have a formula that will look at one cell, and based on that cells value it will select what of the different optional formulas I want.

------------------------------------------------------

Let me explain it again from another angle, because I'm not great with explaining my needs...

I'm trying to get a formula, lets say its for cell B1...I'd like it to look at cell C1 and if C1=1, it should use the formula $D$1*$E$1. If C1=2, it should use the formula $D$2*$E$1. If C1=3, it should use the formula $D$3*$E$1, and so on.

I'm assuming there is some way to do this, I just don't know how to begin looking and I am not the best at coding such things.

Once again, thank you very much for taking the time to read and possibly any advice/answer you can provide to this question!