How do you calculate bonus in Excel?

Answer 1

It depends how the bonus will be allocated - is it a fix amount, is it a percentage of their weekly/monthly salary

Assuming its a % of weekly salary

In cell a1 place the salary for the employee i.e. 250

In cell b1 place =C1*A1

In cell c1 - format it to Percentage using CTRL +1 or through the menu FORMAT

once done add in 25 in to the c1 cell

The figure in B1 will be 25% of whats in a1 - change c1 to change the allocated percentage of bonus.

Change cell a1 for the salary amount.

If you want to have a final total of wage plus bonus then in cell D1 place

=A1+b1

Answer 2

It would be done with a multiplication formula. First you need the original value that you are getting the bonus for and type it into a cell. Say it is in cell A2. Then you need to know what the bonus is. Say it is 10%. You could use the 10% direct in a formula like this:

=A2*10%

You could also put the 10% into the cell, say B1, and then your formula would be:

=A2*B1

Having got the bonus, you would then normally add it onto the original value. Say your bonus calculation is in B2, then in another cell you would have:

=A2+B2

If you are using a different percentage rate, use that instead of the 10%. If it is a fixed bonus that needs to be added, then you would use an addition formula. Say you were adding 100 to the original figure, then it would be:

=A2+100