Thank you to both of you.....with your help I was able to customize it and
make it work.

Thank you, Thank you, Thank you!!!!!

"Eduardo" wrote:

Hi Kdeyton,
if you enter my formula if the value is less than 15000 will show "0" as a
result

"kdeyton" wrote:

That is great! I'm almost there.

What if I need it to show zero if the statement wasn't true?
Looks like this:
47,890.00

0-14999 @ 0%
15000-22000 @ .075% - formula entered here
22001-25000 @ 1.25% - formula entered here
25001-30000 @ 1.50% - formula entered here
30001-35000 @ 1.75% - formula entered here
35001-40000 @ 2.00% - formula entered here
41000 above @ 2.5% - formula entered here
Commissions paid Sum above for range that is calculated

"John C" wrote:

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!