Enter an equal sign followed by an open parenthesis to. To calculate the percentage of a number you just have to insert a number and apply the percentage formatting. To calculate the percent change in excel we need at least two numbers from different time periods.
As with any formula in Excel you need to start by typing an equal sign in the cell where.
For example if we have 2 numbers then to find the percentage increase we will first subtract the smaller number from a bigger number and then divide the obtained value with a smaller number among both the values. You can also choose the number of decimal points youd like in each percentage. For example 10 of 100 is 01 100 10. For example if you want to calculate 20 of 500 multiply 20 by 500.