multiplying by variables based off original number
One way...
=IF(A1<=400,100,A1*IF(A1<=1500,0.25,IF(A1<=2499,0. 3,0.35)))
--
Biff
Microsoft Excel MVP
"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?
|