Trying to multiply data by one cell, based on data of another

[ADC76]

hello,
I'm trying to calculate commission bonuses based on gross sales by
multipling a percentage by the net sales.
Example:
A1= Gross Sales
A2= Net sales
A3= Bonus Commission.
Here's the formula I tried, but it's only working for half the equation:
=IF(A1>=6000,A2*.225,IF(A1>=8000,A2*.25))
The formula works only for the first command (*.225). When I enter 8000 in
the A1 cell, it still (*.225), instead of (*.25).
Any suggestions would be helpful.

 

[Don]

I think you need the and command - I assumed taht you were searching for the
gross Sales in column A and column B was net sales?

=IF(AND(A1>=60000,A1<80000),B1*0.25,IF(A1>=80000,B1*0.25,0))

 

[roadkill]

It looks to me like you just need to test for 8000 first, not 6000. If
A1>8000 it's also greater than 6000 so the test in the first IF is satisfied.
I'd say try:

=IF(A1>=8000,A2*.25,IF(A1>=6000,A2*.225))

Will

 

[ADC76]

Thanks Don! It works great now! Never would have thought to use AND.
I appreciate the quick response too!
ADC76