Calculating percentages in Excel is essential for tracking your data and interpreting results easily. In this article, we will explore the various methods to calculate the percentage of a number in Excel, thereby enabling you to enjoy the full power of this versatile software.

Method 1: Using Formula

Step 1:

To find the percentage of a number in Excel, open an Excel spreadsheet and click on a cell where you wish to display the result.

Step 2:

In the formula bar, type the formula “=A1*(B1/100)”, where A1 represents the cell containing the number you want to find the percentage of, and B1 refers to the cell with the desired percentage. Press Enter.

Example:

If you want to calculate 20% of 150, type “=150*(20/100)” into an empty cell, press Enter, and Excel will display the result (30).

Method 2: Using Cell References

Step 1:

Enter numbers in two separate cells (A1 and B1), with one denoting the value whose percentage you wish to find and the other representing the percentage itself.

Step 2:

In another empty cell, type “=A1*(B1/100)” and press Enter.

Step 3:

The result will be displayed in that cell. If you modify either value in cells A1 or B1, Excel will automatically update the result.

Additional Tip: Formatting Cells for Percentages

You can format cells as percentages directly in Excel. This will simplify data entry and interpretation. To format cells for displaying percentages:

Step 1:

Select the cell/s you want to format.

Step 2:

Right-click on your selection and choose “Format Cells.”

Step 3:

In the Format Cells dialog box, click on “Percentage” under Category. Set your desired decimal places if necessary.

Step 4:

Click “OK” to apply your formatting.

Conclusion:

Excel offers a straightforward and flexible way to calculate percentages, ensuring you can accurately analyze and report your data. By mastering these simple techniques, you will effortlessly make the most of Excel’s abilities and optimize your work efficiency.