Daniel Sloan Wrote:
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

Hi Daniel

Assuming the sales figure to be in cell A1, use this formula

=IF(A1<=75,A1,IF(OR(A175,A1<=150),A1*1.01,IF(OR(A 1150,A1<=300),A1*1.02,A1*1.03)))

Your explanation does not cater for someone getting $150 sales, so have
given $150 1%, you can change the formula if required


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=486761