D
Daniel Sloan
I am attempting to use an IF formula to do the following:
IF sales are less than $75 no commission
IF sales are >=$76 but < $150 1% commission
IF sales are>=$151 but <$300 2% commision
IF sales are> $300 3% Commission
The Commission paid is stepped at each point and any amount in betwee
the breaks also must have the commission paid.
Could some one please provide some pointers as to the right way t
approach this.
Thanks
Danie
IF sales are less than $75 no commission
IF sales are >=$76 but < $150 1% commission
IF sales are>=$151 but <$300 2% commision
IF sales are> $300 3% Commission
The Commission paid is stepped at each point and any amount in betwee
the breaks also must have the commission paid.
Could some one please provide some pointers as to the right way t
approach this.
Thanks
Danie