C
Chlang
Hi
I need help on two things:
Firstly, I am calculating a new business commission of 1% over a 3 month
basis.
If the campaign doesnt run as it should in the fourth month a clawback will
kick in. Thisis manually checked but I want Excel to calculatethe final
commissions.
I only want the clawback to deduct from that months commission if its over
£50.00, anything under £50.00 is written off.
Therefore New commission - Clawback (only over £50.00) = Paid commission
that month.
I think I need to use an If Statment but having only used these in training
Im finding it hard to put it into practical use.
Also, I need to work out:
If 100% of target is hit x amount of commision is payed
If 102% of target is hit y amount of commission is payed.
etc.
Again, maybe a Nested If Statement is required - I juts need a bit of
guidance.
(These two workbooks are linked as a final sheet Normal Commission + New
Business commission = Payable commission.)
Cheers
Chlang.
I need help on two things:
Firstly, I am calculating a new business commission of 1% over a 3 month
basis.
If the campaign doesnt run as it should in the fourth month a clawback will
kick in. Thisis manually checked but I want Excel to calculatethe final
commissions.
I only want the clawback to deduct from that months commission if its over
£50.00, anything under £50.00 is written off.
Therefore New commission - Clawback (only over £50.00) = Paid commission
that month.
I think I need to use an If Statment but having only used these in training
Im finding it hard to put it into practical use.
Also, I need to work out:
If 100% of target is hit x amount of commision is payed
If 102% of target is hit y amount of commission is payed.
etc.
Again, maybe a Nested If Statement is required - I juts need a bit of
guidance.
(These two workbooks are linked as a final sheet Normal Commission + New
Business commission = Payable commission.)
Cheers
Chlang.