How do you calculate deduction in Excel?

Answer 1

There are various ways, depending on the type of deduction, or if you want to get the actual deduction or the total remaining after. You can get a percentage and take it away from the amount. For a 10% deduction you could do this to get the deduction, where the initial value is in A2:

=A2*10%

To get the total remaining after the deduction:

=A2-A2*10%

Or you could do it this way:

=A2*90%

If you know the fixed amount to be taken off, say 150, then you could do this:

=A2-150

You could calculate all the deductions and then use the SUM function to add them up, if you are looking for total deduction.

If it is individual deductions like tax, insurance, pension etc., they can be individually calculated and then added together to get the total deduction for the person.