This interactive demo was created free with Storylane in 8 minutes. Create your own demo
How to Calculate Bonus in MS Excel
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.
