Saturday, January 22, 2011

How to Subtract a Percentage in Microsoft Excel


1. Enter the amount you want to subtract a percentage from in cell A1. For example, if you wanted to subtract 20 percent of $80, you would enter '80' in cell A1.
2. Enter the percentage you want to subtract in cell A2. For example, if you wanted to subtract 20 percent of $80, you would enter '20' in cell A2.
3. Enter '=A1*(1-A2/100)' in cell A3 to have Excel calculate the find value. For example, when you enter the formula with 80 in A1 and 20 in A2, you will get 64, value of 80 minus 20 percent of 80.

Blogger news