Excel formula program
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
Software/Hardware used:
microsoft office 32007
ASKED:
February 23, 2013 1:59 AM
UPDATED:
February 25, 2013 1:47 PM
Answer Wiki:
Last Wiki Answer Submitted:
Be the first to answer this question.
All Answer Wiki Contributors:
Be the first to answer this question.
Michael Tidmarsh 
11,380 pts. ,
natmail 10 pts.
11,380 pts. ,
natmail 10 pts. To see all answers submitted to the Answer Wiki: View Answer History.
That might be something like this: If(F9>35000,35000*0.35 + (F9-35000)*0.10,F9*0.35)