Which Formula In Excel Which Will Deduct 20% From Any Number?

Question

2 Answers

Answer 1

To complete this calculation in excel you need to use a simple formula in a cell as below:

=YourNumber*(1-0.2)

Examples of How To Take 20% in Excel

Using a number eg 20:
=20*(1-0.2)

Using a cell eg a1:
=A1*.8

If the percentage to be deducted is found in another cell (say B1), then you can format that cell as % and use this sort of formula.
=A1*(1-B1)

More Advanced Techniques for 20% Calculations

=Round(A1*.8,0)

If the percentage to be deducted is found in another cell (say B1), then you can format that cell as % and use this sort of formula.

Answer 2

If you just want to take 20% off of the number, multiply by .8

Example
=A1*.8

If you want the result to be rounded to a whole number, then you need to use a function that will do rounding.

=Round(A1*.8,0)

If the percentage to be deducted is found in another cell (say B1), then you can format that cell as % and use this sort of formula.

=A1*(1-B1)

If you want to type 20 into cell B1, rather than 20%, then you have to do the conversion in your formula.

=A1*(1-B1/100)