Assuming less than 15,000 is 0%
Enter this in Col C
0
15000
22001
25001
30001
35001
40001
Enter this in Col D
0
0.08%
1.25%
1.50%
1.75%
2%
2.50%

Enter this in B1
=VLOOKUP(A1,C:D,2,TRUE)*A1
and copy down


"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!