# How to calculate bonus in ms excel

> To calculate bonus in Excel, open your file, enter the VLOOKUP formula under the Bonus column, apply the percentage format from the ribbon, enter the total formula, and highlight both cells to copy the formulas down.

Canonical: https://livedemo.ai/tutorials/how-to-calculate-bonus-in-ms-excel/
Apps: Excel
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a3050d673bd5aa8e62ee9/preview?step=1

## Steps

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.