|The simple answer is the brute force method:|
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*C2
You 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.
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.