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

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(39617) (Show Source): You can put this solution on YOUR website!

s     amount of sales
c     amount that salesman gets

?
If true then salesman gets 15% of this quantity.

If can be accepted to every nearest penny, then

RELATED QUESTIONS
I need to know how do do a formula.... if a salesman gets 15% of every thousand dollars... (answered by ikleyn)

Jason gets 15 dollars for every hour he works as a photographer. He gets 10 dollars every (answered by stanbon)

if a salesman made 25,000.00 in sales after 3 months, and after 23 months he made... (answered by stanbon)

Mr. Spoke is a salesman at Pop's Cycle Shop. Each month he earns $800 plus 7% of his... (answered by checkley71)

If John gets paid 2000 dollars every month and also gets a 10% bonus monthly, how much... (answered by Theo)

"A salesman earns 5% commission on his total sales and a flat rate of $15 an hour. If he... (answered by josmiceli)

A salesman earns 15 pesos for every two radio clocks that he sells. If he manages to... (answered by josgarithmetic)

local salesman receives a base salary of $825 monthly. He also receives a commission of... (answered by Boreal)