Here's how to do it:
- Open the file you wish to edit.
- 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.
- Go to the Excel ribbon, click on ''Number,'' and then select the ''%'' format.
- 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.
- Highlight both the cells under the ''Bonus'' and ''Total'' columns to apply the formula to the remaining cells below.
