How to Calculate Bonus in MS Excel

Updated on:

April 6, 2026

By:

Madhav Bhandari

Use this interactive demo to learn how to calculate bonuses in Microsoft 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.

📌 Why this matters

Calculating bonuses automatically prevents manual errors that can damage employee trust and create costly payroll discrepancies. You can instantly adjust bonus rates or eligibility criteria and see results across your entire workforce without recalculating each employee individually.

This approach also creates an audit trail for HR compliance and performance reviews. When bonus structures change seasonally or quarterly, your formulas adapt immediately, saving hours of repetitive work while ensuring consistent, transparent compensation decisions that employees can understand and verify.

Your product deserves an interactive demo

Start free

How to Organize Dates by Week in Excel

How to Make Cells Fit Text Microsoft Excel

How to Make a Bar Graph in Microsoft Excel