2 more options:
=A1*LOOKUP(A1,{0,0;15000,0.00075;22001,0.0125;2500 1,0.015;30001,0.0175;35001,0.02;40001,0.025})

or

=A1*(0.075%*(A1=15000)+1.175%*(A1=22001)+0.25%*( (A1=25001)+(A1=30001)+(A1=35001))+0.5%*(A1=400 01))

--
** John C **

"kdeyton" wrote:

I have been trying for hours to enter a formula that will allow me to do the
following:
If cell A1 is Between 15000 and 22000 than A1 times .075%
If cell A1 is Between 22001 and 25000 than A1 times 1.25%
If cell A1 is Between 25001 and 30000 than A1 times 1.5%
If cell A1 is Between 30001 and 35000 than A1 times 1.75%
If cell A1 is Between 35001 and 40000 than A1 times 2%
If cell A1 is 40001 and above than A1 times 2.5%

Please Help, I need to your assistance so I can move on with the rest of my
day!
Thank you in advance!