The formula in parentheses calculates the percentage which the remainder of the formula subtracts from the original amount. Calculate a Percentage of a number in Excel Percentage is an expression of part of the whole. Then type the following formula.
Before writing any formulas its helpful to know that Excel is flexible enough to calculate the same way whether you type percentages with a percent sign like 20 or as a decimal like 02 or just 2.
To increase the amount by a percentage use the same formula but simply replace the Plus sign with a Minus sign -. In the example shown the formula in D6 is. For example You got the marks 70 out of 100 in Mathematics subject. To show a number as a percent in Excel you need to apply the Percentage format to the cells.