Part Whole 100. Number 1 is subtracted by the percentage discount. 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.
Create an Excel formula to calculate the percentage of one number of another numberFREE Excel Formulas Begi.
A290 A209 Because of the way Excel handles percentages it sees these formulas as exactly the same thing. Number 1 is subtracted by the percentage discount. On the Home tab in the Number group click the percentage symbol to apply a Percentage format. The percentage of change between the two years is 23.