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?