multiplying by variables based off original number

  • Thread starter Thread starter jato
  • Start date Start date
J

jato

trying to figure this out, im in commsionned sales, and we base our commision
off a percentage of our gross, i need a formula that basically does this
400 or less=100
1500 or less *.25
1501-2499*.3
2499<*.35
all in one formula.... is this possible?
 
Combine the below formula...to yours...

=LOOKUP(A1,{0,401,1501,2500},{100,0.25,0.3,0.35})

If this post helps click Yes
 
jato said:
trying to figure this out, im in commsionned sales, and we base our commision
off a percentage of our gross, i need a formula that basically does this
400 or less=100
1500 or less *.25
1501-2499*.3
2499<*.35
all in one formula.... is this possible?
Click to expand...

Hi J.
One more try, see if it fits your numbers.
Commission =MAX(100,0.25*A1,0.3*A1-75,0.35*A1-200)
The definitions leave room for different formulas, check this one out too.
Hans T.
 
Back
Top