Find Percentage in Excel

Introduction to Finding Percentage in Excel

Excel is a powerful tool used for various calculations, including finding percentages. Percentages are used to express a proportion or a fraction of a whole as a part of 100. In this post, we will explore how to calculate percentages in Excel, including how to increase or decrease a value by a certain percentage, find the percentage of a total, and calculate the percentage change between two values.

Calculating Percentages in Excel

To calculate a percentage in Excel, you can use the formula: (part/whole) * 100. For example, if you want to find 20% of 100, you would use the formula =(20/100)*100 or simply =20%*100.

Here are the steps to calculate percentages: - Step 1: Open your Excel spreadsheet and select the cell where you want to display the percentage. - Step 2: Type = to start your formula. - Step 3: Enter the percentage value (e.g., 20 for 20%). - Step 4: If you’re finding a percentage of a number, divide the percentage by 100 (to convert it to a decimal) and then multiply by the number. - Step 5: Press Enter to get the result.

Increasing or Decreasing a Value by a Percentage

To increase or decrease a value by a certain percentage, you can use the following formulas: - To increase by a percentage: =original_value * (1 + percentage) - To decrease by a percentage: =original_value * (1 - percentage)

For example, to increase 100 by 20%, you would use =100*(1+20%), and to decrease 100 by 20%, you would use =100*(1-20%).

Finding the Percentage of a Total

If you want to find what percentage one number is of another, you can use the formula: (part/whole) * 100. For instance, to find what percentage 20 is of 100, you would use =(20/100)*100.

Calculating Percentage Change

To calculate the percentage change between two values, you can use the formula: ((new_value - old_value) / old_value) * 100. For example, if the old value is 100 and the new value is 120, the formula would be =((120-100)/100)*100, which equals 20%.

Formatting Cells as Percentages

After calculating percentages, you might want to format the cells to display the percentages correctly. Here’s how: - Step 1: Select the cells you want to format. - Step 2: Right-click on the selected cells and choose “Format Cells” (or press Ctrl + 1). - Step 3: In the Format Cells dialog box, click on the “Number” tab. - Step 4: Select “Percentage” from the Category list. - Step 5: Choose the number of decimal places you want to display. - Step 6: Click OK.

Common Percentage Formulas in Excel

Here are some common percentage formulas used in Excel: - Percentage of a number: =number * percentage - Percentage increase: =original_value * (1 + percentage) - Percentage decrease: =original_value * (1 - percentage) - Percentage change: =((new_value - old_value) / old_value) * 100

Formula	Description
=number * percentage	Calculates a percentage of a number
=original_value * (1 + percentage)	Increases a value by a percentage
=original_value * (1 - percentage)	Decreases a value by a percentage
=((new_value - old_value) / old_value) * 100	Calculates the percentage change between two values

📝 Note: Always ensure that your percentages are in decimal form when using them in calculations (e.g., 20% should be entered as 0.20 in formulas).

To sum up, calculating percentages in Excel is straightforward and can be achieved through simple formulas. Whether you’re increasing or decreasing values by a percentage, finding the percentage of a total, or calculating the percentage change, Excel provides the tools to do so efficiently. With practice, you’ll become proficient in using these formulas to analyze and manipulate data in your spreadsheets.