Multiple Commands with Variables

How do I set this formula?

I am trying to tell a cell to perform a mathematical function dependant on the information entered. For example:

if b22 is = to 1.25 to 2.49, than multiply d22 by 4.5%
if b22 is = to 2.50 to 3.74 than multiply d22 by 6.5%

and so on all the way up to 9 different scenarios.

Is this possible?

Originally Posted by Colin Legg

Hi,

What would the factor be if B22 < 1.25? 2.5%?

It is a range of pay out tiers. I am trying to build a model that allows the user to input different pay out structures to compare the results if tiers were changed. So the below is an example of 1 tier

If b22 is between the amounts of 1.25 to 2.49 than the entered amount for cell D22 will be multiplied by 4.5%

If b22 is between the amounts of 2.50 and 3.74 than the entered amount for cell d22 will be multiplied by 6.5%