answersLogoWhite

0


Best Answer

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.

User Avatar

Wiki User

10y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you calculate deduction in Excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What excel formula can be used to calculate FICA?

If the employee's gross pay is in column A, line 1, and you want the FICA deduction in column B, then the formula in B1 is A1*.0765


Why is MS Excel is called Excel?

MS-Excel is a powerful worksheet & you calculate , syncronize many hard calculation, so MS-Excel is called Excel.


How do you calculate sharpe ratio in Excel?

The related link provides an excel template and some notes on how to calculate the sharpe ratio..pretty simple and effective.


What formula is used to calculate quantity?

You can calculate quantity in Excel with the SUM function.


How do you calculate degrees of freedom on excel?

Utilizing the visual basic functions built into excel worksheets you can calculate degrees of freedom. The function call that you use for this is "degrees_freedom".


What is the use of MS excel 2007?

you may calculate


Is cost of goods sold and expense?

From a financial reporting standpoint, no. Cost of Goods Sold (COGS) is shown on the income statement below sales as a deduction to calculate gross profit. Expenses are shown as a deduction from gross profit to calculate net profit.


How do you calculate treynor ratio in Excel?

calculate the effective return (mean return minus the risk free rate) divided by the beta. the excel spreadsheet in the related link has an example.


How do you calculate Microsoft Excel sheet Debt-Service Coverage Ratio - DSCR?

Calculating DSCR in Excel sheet


On Microsoft Excel what do you need to write to calculate things?

Formulas.


How do you calculate a discount in Microsoft Excel?

See the explanation in the related link.


What is Cash Flow Excel and what does it do?

Cash Flow Excel are spreadsheets created by excel to help manage your money. They calculate balances on accounts as well as help you to budget your money effectively.