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!