For every successful candidate placement £10 per week will be paid on top of your basic for every week the candidate works. This bonus will be included in your monthly gross pay. For example every week we calculate the number of candidates you have placed and are working for you, this number is multiplied by £10.00 ie in a 5 week month where you have 5 candidates placed and working you will receive £50 x 5 = £250 in that months gross salary. Can you help with the formula

The simple answer is the brute force method: =5*5*10

This will produce the £250 noted in your example.

The better way, since I assume the values will vary, is to set up a table:

A B C D 1 Candidates Weeks Bonus Rate Bonus Total 2 5 5 10 =A2*B2*C2You can drag the formula in D2 (and the 10) down as far as you need if you want to keep track of each pay period.

You could also put the "10" (which I assume will be constant over a long time period) in a single cell and always refer to that cell in your formulas. e.g.

=A2*B2*$C$2

When you drag that down, the $C$2 will not change and all formulas will use the value in C2. However, if they ever change that rate and you change the value in C2, all of the "past values" will also change.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Ask Your Question

Weekly Poll