Struggling to Calculate Percentage in Excel? Here’s How to Do It!

To calculate percentage in Excel, start by dividing the part value by the total value and then multiply by 100. For example, if you have a score of 50 out of 200, enter =50/200*100 to get the percentage. Many people get stuck on using the right formula or formatting the results correctly. 

This guide will walk you through easy steps to calculate percentage in Excel and help you make your results clear and accurate every time.

How to Calculate Percentage in Excel? Formulas and Examples

Excel is a powerful tool packed with formulas and functions that make calculations and data analysis straightforward. One key skill is knowing how to calculate percentage in Excel, which comes up often in sales reports, grades, and financial data.

Calculating a percentage means finding what portion one number is of another and expressing it as a fraction of 100. In Excel, this is done by dividing the numerator (part) by the denominator (total) using a simple formula like =Numerator/Denominator. You don’t always need to multiply by 100 if you format the result as a percentage. By learning how to calculate percentage in Excel, you can save time and ensure accuracy in your data analysis.

Here’s how to enter this formula smoothly:

• Select the cell where you want the result.
• Type = to start the formula, then use cell references (like A1/B1) instead of typing numbers directly. This keeps your calculations flexible and easy to update.
• Press Enter to calculate the result.
• To display the decimal as a percentage, press Ctrl + Shift + % or click the % button in the Home tab’s Number group.

This approach ensures your percentages update automatically when your data changes, and your worksheet stays clean and easy to manage. Avoid hardcoding numbers in formulas and always double-check your cell references to prevent errors.

Handling percentages in Excel isn’t just about plugging numbers into formulas. You need to know how to manage, calculate, and interpret those percentages correctly to make your data meaningful across different scenarios.

• Masters in Data Science Degree
• Executive Diploma in Data Science & AI with IIIT-B
• Executive Diploma in Machine Learning and AI with IIIT-B

1. How to Calculate Percentage in Excel Using =Part/Total

Calculating percentages in Excel is easier than it sounds. At its core, finding a percentage means figuring out what part one number is of another. In Excel, this is done by dividing the part by the total. Once you enter the formula, you just need to format the result to show it as a percentage. Knowing how to calculate percentage in Excel helps optimize your work and ensures accuracy in your calculations.

This simple process helps you quickly turn raw numbers into meaningful insights, whether you’re working on sales data, grades, or budgets.

Step 1: Understand the Formula
The basic formula to calculate a percentage is:

=Part / Total

• Part is the portion or amount you want to find the percentage of.
• Total is the whole or total amount.

This formula divides the part by the total to get a decimal number. For example, if you want to find what percentage 5 is of 20, you write =5/20. This gives you 0.25.

Step 2: Enter Your Data in Excel

To calculate percentage in Excel, the first thing you need to do is enter your data. Here’s how to do it step by step:

1. Open Excel: Launch the Excel application on your computer and select a blank worksheet to start fresh.
2. Enter the Part Value: In cell A1, input the value that represents the part or subset of the total. For example, if you want to find out what percentage 5 is of 20, enter 5 in cell A1.
3. Enter the Total Value: In cell B1, input the total value, which is the whole or base number that the part is being compared to. In this case, enter 20 in cell B1.

Step 3: Write the Percentage Formula

Now that you've entered your data, it's time to write the formula to calculate percentage in Excel. Follow these steps to get your result:

1. Select the Result Cell: Click on cell C1, where you want the percentage result to appear. This is the cell where Excel will display the calculated percentage.
2. Enter the Formula: In the formula bar, type the following formula:
   CopyEdit
   =A1/B1
3. This formula divides the part value (in cell A1) by the total value (in cell B1) to calculate the proportion.
4. Press Enter: Once you’ve entered the formula, press the Enter key. Excel will automatically perform the division and display the result in cell C1.

Step 4: Format the Result as a Percentage

Once you've written the formula and obtained the decimal result, the next step is to format it as a percentage. Follow these steps to calculate a percentage in Excel and convert the decimal into an easy-to-read percentage:

1. Select the Result Cell: Click on cell C1, where the decimal result (such as 0.25) is displayed.
2. Go to the Home Tab: At the top of the Excel window, go to the Home tab on the Excel ribbon. This tab contains the majority of the formatting and editing tools you’ll need.
3. Click the Percent Style Button: In the Number group on the ribbon, you will see an option called Percent Style(it looks like a percentage symbol, "%"). Click on this button.
4. Result Conversion: Excel will automatically convert the decimal number (0.25) into a percentage format, changing it to 25%. This makes it much easier to interpret the result, as you now have the percentage representation of the value.

Step 5: Adjust Decimal Places (Optional)

With cell C1 still selected, click the Increase Decimal or Decrease Decimal buttons next to the % button to show more or fewer decimal places (e.g., 25.00%).

Summary Example:

That’s it! You’ve calculated a percentage in Excel using the simple =Part/Total formula and formatted the result as a percentage.

Also Read: 60 Advanced Excel Formulas – A Must Know For All Professionals

2. Calculate the Percentage of Variation in Excel

When you want to figure out how much two values change from one another in relation to the starting value, calculating the percentage of variation is an important step. This is particularly useful in scenarios like comparing sales growth, price changes, or performance metrics. Here's a step-by-step guide to calculate the percentage of variation in Excel:

Step 1: Open Excel

Open the Excel application on your computer and select a blank worksheet to begin.

Step 2: Enter the Starting Value

In cell A1, enter the starting value. For example, let’s say you want to compare the initial value of 100 with a later value of 150. Enter 100 in cell A1.

Step 3: Enter the Result Value

In cell B1, enter the result value that you want to compare with the starting value. For instance, if the final value is 150, enter 150 in cell B1.

Step 4: Enter the Percentage Formula

In cell C1, enter the following formula to calculate the percentage change (variation) between the two values:

=((B1-A1)/A1)*100

This formula calculates the difference between the result value (cell B1) and the starting value (cell A1), divides that difference by the starting value, and then multiplies it by 100 to get the percentage.

Step 5: Press Enter

Once you've entered the formula in cell C1, press Enter. Excel will perform the calculation based on the values in cells A1 and B1.

Step 6: View the Result

After pressing Enter, cell C1 will display the outcome of the calculation. In this case, the result will be 50, indicating a 50% increase from the starting value of 100 to the final value of 150.

Also Read: Ribbon in Excel: A Comprehensive Guide to Explore in 2025

3. Increase or Decrease a Number Using the Percentage

Sometimes, you need to find out how much a value has gone up or down compared to its original amount. Excel helps you calculate this easily using simple formulas for percentage increase and decrease. Understanding these calculations is useful for tracking growth, losses, or changes in data like sales, prices, or scores.

• To calculate percentage increase, subtract the old value from the new value, then divide that result by the old value:

(New - Old) / Old

This tells you how much the number has grown compared to where it started.

• To calculate percentage decrease, subtract the new value from the old value, then divide by the old value:

(Old - New) / Old

This shows how much the number has fallen from its original amount.

After entering these formulas in Excel, format the result cell as a percentage to see the increase or decrease clearly.

Increasing or Decreasing a Number by a Percentage

Sometimes you need to add or subtract a certain percentage from a number. For example, calculating a price after a discount or a salary increase. Excel makes this easy with simple formulas.

To increase a number by a percentage:

1. Suppose the original number is in cell A1 (e.g., 200).

2. The percentage increase is in cell B1 (enter it as a decimal or percentage, for example, 10% or 0.1).

In cell C1, enter the formula:
=A1 * (1 + B1)

3. Press Enter. Excel will show the increased value (for 200 increased by 10%, the result will be 220).

To decrease a number by a percentage:

1. Original number in A1 (e.g., 200).

2. Percentage decrease in B1 (e.g., 15% or 0.15).

In C1, enter:
=A1 * (1 - B1)

3. Press Enter. Excel will calculate the decreased value (for 200 decreased by 15%, the result will be 170).

Note:

• Make sure cell B1 is formatted as a percentage or entered as a decimal.
• This method works for any percentage increase or decrease and can be applied to prices, quantities, or any numeric data.

This formula keeps your calculations clear and lets you quickly adjust numbers based on percentages.

Also Read: 30 Data Science Project Ideas for Beginners in 2025

Now that you know how to calculate percentages in Excel, let's explore some formatting tips to ensure your results look clean and professional.

Formatting Tips for Percentages in Excel

Once you calculate percentages in Excel, how they appear on your screen makes a big difference. Proper formatting helps you read and interpret your data quickly and accurately. Excel offers simple tools to display numbers as percentages without needing to change your formulas.

Use Excel’s Percentage Format:

Once you’ve entered your formula, such as =A1/B1, follow these steps to format the result as a percentage:

1. Select the Result Cell: Click on the cell where the result of your formula appears (for example, cell C1). This is the cell that you want to display as a percentage.
2. Go to the Home Tab: At the top of your Excel window, go to the Home tab. This is where you’ll find most of the formatting options for your data.
3. Click the Percent Style Button: In the Number group, you will see a button labeled Percent Style (%). Clicking this will convert the decimal value (e.g., 0.25) into a percentage (25%).

Using the Percent Style button is preferable to manually multiplying by 100 in your formula. It optimizes your calculations and ensures that your results are consistently formatted as percentages, reducing the chances of errors and keeping your formulas clean.

Adjust Decimal Places:

Occasionally, you may want to adjust how many digits appear after the decimal point in your percentage result. Here’s how you can do it:

1. Select the Percentage Cell: Click on the cell containing the percentage result that you want to modify (e.g., cell C1).
2. Use the Increase or Decrease Decimal Buttons: On the Home tab, in the Number group, you’ll see two buttons next to the Percent Style (%) button: Increase Decimal and Decrease Decimal.
   • To show more decimal places, click Increase Decimal.
   • To show fewer decimal places, click Decrease Decimal.
3. Adjust the Precision: Each time you click one of these buttons, you can control how precise your percentage result looks. For example, you can change a result from 25% to 25.0% or 25.00%, depending on how many decimal places you prefer.

This feature helps you fine-tune the level of detail in your percentage display, giving you control over its appearance.

Avoid Common Formatting Mistakes:

To ensure your percentage calculations are accurate and your data is properly formatted, follow these tips:

1. Avoid Multiplying by 100: Don’t multiply your formula by 100 and then format the cell as a percentage. Doing so will display the number 100 times larger than intended. For instance, if you divide 50 by 200 and multiply by 100 in your formula, you’ll get 25%. But formatting the result as a percentage would display it as 2500% instead of 25%.
2. Ensure Consistent Input Data: Make sure your input data is consistent throughout your worksheet. If you enter values as decimals in formulas (e.g., 0.25), don’t also format those input cells as percentages (e.g., 25%)—or your results could be incorrect. Formatting them as percentages will make Excel interpret them differently, leading to inaccurate calculations.

Use Cell Styles for Consistency:

When working with multiple percentage cells, it’s essential to maintain a consistent format across your worksheet. Here’s how to streamline the process:

1. Select the Range of Cells: Click and drag to select the range of cells that you want to format as percentages. You can select multiple cells across rows or columns where you want the percentage format applied.
2. Apply the Percentage Format: With the cells selected, go to the Home tab, and click the Percent Style (%)button in the Number group. This will apply the percentage format to all the selected cells at once.
3. Maintain Uniformity: By applying the percentage format to a range of cells in one step, you ensure that your worksheet looks uniform and professional. This approach saves you time and avoids inconsistencies in how your data is presented.

Properly formatting percentages makes your data easier to understand and your spreadsheets look polished. It’s a small step that can prevent big misunderstandings in your analysis.

Try applying these formulas to your own data sets. Practice with real numbers like sales figures, test scores, or budgets to get comfortable. Remember to always format your results as percentages to avoid confusion.

Keep your formulas simple and double-check cell references when copying them across rows or columns. This will help you avoid errors and make your spreadsheets more reliable.

Also Read: Top 15 Ways to Improve Excel Skills [Actionable Tips] 

Now that you've learned how to format percentages in Excel, it's time to take your Excel skills to the next level with upGrad.

Take the Next Step in Excel with upGrad!

Calculating percentage in Excel starts with dividing the part by the total and formatting the result as a percentage. This blog covered basic formulas, how to enter them, percentage increase and decrease calculations, adjusting values by percentages, and tips for formatting and avoiding common mistakes.

Despite these straightforward steps, many still struggle with applying these formulas correctly and interpreting results in their data sets. This is where upGrad can help with its detailed courses.

• Professional Certificate Program in Business Analytics & Consulting in association with PwC Academy
• Master the Future of Data with Microsoft 365 Copilot

Here are some recommended free courses as well to get started:

• ChatGPT for Developers
• Advanced Prompt Engineering Course with ChatGPT
• Introduction to Generative AI

To help bridge this gap, upGrad’s personalized career guidance can help you explore the right learning path based on your goals. You can also visit your nearest upGrad center and start hands-on training today!

Enhance your expertise with our Popular MBA Courses. Explore the programs below to find your ideal fit.

Explore our Popular MBA Courses

Expand your knowledge with our Popular Articles Related to MBA. Browse the programs below to discover your ideal match.

Read Our Popular Articles Related to MBA

References:
https://www.guvi.in/blog/full-stack-development-trends/