The opposite is true when calculating percent decrease. To convert the B2 value into percentages you need to apply percentage formatting to this cell. Now to calculate the percentage we have to know its formula.
Open up the Format Cells dialog box by either.
Enter an equal sign followed by an open parenthesis to. Enter an old number in cell A1 and a new number in cell B1. You can find it in the Home Number area. To calculate the percentage of a specific number you first convert the percentage number to a decimal.