Solved excel help for commission formula

October 22, 2014 at 11:40:33
Specs: Windows XP
Calculating commissions.

Commission for the month is at 8% on the first $30,000 and anything over $30,000 is at 10%


See More: excel help for commission formula

Report •


#1
October 22, 2014 at 12:04:00
Try this:

With your compensation in cell A1
put this formula in B1

=IF(A1<=30000,A1*8%,A1*10%)

Also, in the future, Excel questions are best asked in the Office Software forum.

MIKE

http://www.skeptic.com/

message edited by mmcconaghy


Report •

#2
October 22, 2014 at 21:01:34
✔ Best Answer
If I understand your question correctly, the commission on 32,000 would be:

30,000 x 8% plus 2,000 x 10%

2,400 + 200 = 2,600

The formula for that calculation is:

=IF(A1>30000,(A1-30000)*0.1+2400,A1*0.08)

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions


Ask Question