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.