Guide

1. Open the file you wish to edit.

2. In the cell under 'Bonus', type the formula =VLOOKUP(B2,$G$3:$H$24,2,FALSE), as shown in the example, where the cells contain the positions of the different employees.

3. Go to the Excel ribbon, click on ''Number,'' and then select the ''%'' format.

4. Under ''Total'', type the formula =C2*(D2=1)As per the example provided, the calculation is based on the values in columns C and D.

5. Highlight both the cells under the ''Bonus'' and ''Total'' columns to apply the formula to the remaining cells below.