Sorry, half asleep ignore all of my postings
Off to bed!!!

Regards
Roger

Roger Govier
Technology 4 U

Tel 01873 880266 Mob 07970 786191



Roger Govier wrote:

Hi

Your original posting said

IF 16000, 100% of the amount 16000 is multiplyed by 100%

You have since said that if amount 16000, then 60% of amount up to
16000, plus all of excess over 16000.
If so then change formula to

=(A10)*45%+(A17000)*5%+(A19000)*5%+(A113000)*5 %+MAX(0,A1-16000)



Roger Govier


Roger Govier wrote:

Hi

=IF(A116000,A1,(A10)*45%+(A17000)*5%+(A19000)* 5%+(A113000)*5%)

Regards

Roger Govier


cbrock wrote:

I am trying to create a formula that will calculate commissions
depending on bechmarks.
Example:
IF <7000 then multiply by 45%
IF 7000, but <9000 then multiply by 50%
IF 9000, but <13000 then multiply by 55%

The final part of the formula should be as follows:
If 13000, but <16000 then multiply by 60%, IF 16000, 100% of the
amount

16000 is multiplyed by 100%