The formula in parentheses calculates the percentage which the remainder of the formula subtracts from the original amount. - which gives the result 125. Type the following formula into any Excel cell.
To increase the amount by a percentage use the same formula but simply replace the Plus sign with a Minus sign -.
First click into cell D2 so the percentage shows up in the Percentage column. In other words the formula A211 is equivalent to A2011. If you want to calculate a percentage of a number in Excel simply multiply the percentage value by the number that you want the percentage of. For example 11 is actually stored as 011 and Excel uses this underlying value in all formulas and calculations.