For example if you want to calculate 20 of 500 multiply 20 by 500. For example 10 of 100 is 01 100 10. In the Home menu navigate to the Numbers menu.
Enter the formula C2B2 in cell D2 and copy it down to as many rows as you need.
The percentage increase between September and October is 25 with this figure shown as a decimal number 025 by default in Excel using the formula above. We will use two buttonsone to format the cell value as a percentage and another to reduce the number of decimal places so that the cell only shows the tenths place. Number percent 100. Enter the formula C2B2 in cell D2 and copy it down to as many rows as you need.