## Excel formula program

10 pts.
Tags:
Excel 2007
Microsoft Excel formulas
Hi, I'm trying to do a table where I need to calculate how much commission I'm paying for a company. Before 35,000, I pay 35% commission after 35000 I pay 10%. The formula I have right now is =(IF(F9>=35,F2:F8*0.1,(IF(\$F\$9<=35,F2:F8*0.35)))) and it works, but... I don't want the whole column to change to 10% because I want to be able to tabulate the whole amount in the year. Never mind ... found it myself!!

Software/Hardware used:
microsoft office 32007
Related Questions

## Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

## Discuss This Question: 1 Reply

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
• That might be something like this:  If(F9>35000,35000*0.35 + (F9-35000)*0.10,F9*0.35)
54,090 pointsBadges:
report