"jato" wrote in message ...
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?

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.