SOLUTION: I need to know how To create a formula.... if a salesman gets 15% of every thousand dollars he sales after $27000. How would I write the formula in excel? So for exanlole. I

Algebra ->  Customizable Word Problem Solvers  -> Finance -> SOLUTION: I need to know how To create a formula.... if a salesman gets 15% of every thousand dollars he sales after $27000. How would I write the formula in excel? So for exanlole. I      Log On

Ad: Over 600 Algebra Word Problems at edhelper.com


    

Question 1064051: I need to know how To create a formula.... if a salesman gets 15% of every thousand dollars he sales after $27000. How would I write the formula in excel?

So for exanlole. I want to plug unit a formula if sale is 30,000. They would get 15% on 3000.

So 15% per 1000 over 27000. What is the formaula I wold need to create?
Answer by josgarithmetic(39616) About Me  (Show Source):
You can put this solution on YOUR website!
s     amount of sales
c     amount that salesman gets


s-27000%3E0 ?
If true then salesman gets 15% of this quantity.

If s-27000 can be accepted to every nearest penny, then
c=0.15%28s-27000%29