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

A

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.
 
D

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))
 
R

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
 
A

ADC76

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Two formulas in on cell based on two numbers in another cell? 5
Trying to calculate results in one cell, based on data of another 9
multiple inputs, multipul outputs (part 2) 3
Sending data from one cell to another 2
Sum based on date in another cell 5
Commision Rate by margin 4
copy data from one worksheet and disregard blank cells 6
Cell Data by Column 3

Top