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 between
the breaks also must have the commission paid.
Could some one please provide some pointers as to the right way to
approach this.
Thanks
Daniel
--
Daniel Sloan
------------------------------------------------------------------------
Daniel Sloan's Profile:
http://www.excelforum.com/member.php...o&userid=28940
View this thread:
http://www.excelforum.com/showthread...hreadid=486761