How to calculate percentage in excel (Excel me Percentage ka Formula)

Certainly! Let’s dive into the topic of how to calculate percentage in excel or excel me percentage ka formula. In this blog post, I’ll cover the basics of percentage formulas, provide examples, discuss advantages, and explain how to use them effectively.

Excel Percentage Basics

The term “percent” comes from the Latin word “per centum,” which means “by the hundred.” A percentage is essentially a fraction of 100. You can calculate it by dividing the numerator by the denominator and then multiplying the result by 100. The basic percentage formula is as follows:

excel me percentage ka formula
excel main percentage ka formula

For instance, imagine you have 20 apples, and you give 5 of them to your friends. To find out how much you’ve given as a percentage, you’d perform the following calculation:

Percentage formula in excel
Percentage formula in excel

Excel’s Percentage Formula (Percentage ka formula in excel)

In Microsoft Excel, there isn’t a single universal formula for calculating percentages that covers all scenarios. However, Excel makes percentage calculations easier by performing some operations automatically in the background. Here’s the basic formula to calculate percentage in Excel:


Notice that Excel doesn’t require multiplying the resulting fraction by 100. When you apply the Percentage format to a cell, Excel handles the multiplication by 100 for you.

Know how to create chart in excel

Example: Calculating Delivered Products Percentage

Let’s say you have a spreadsheet with the number of ordered items in column B and the number of delivered items in column C. To find the percentage of delivered products, follow these steps:

  1. In cell D2, enter the formula: =C2/B2
  2. Copy this formula down to as many rows as needed.
  3. Select D Column and select Percentage as column type from menus as below
excel me percentage ka formula image
excel me percentage ka formula image

Now you’ll have the percentage of delivered items based on the ordered quantity.

How to calculate percentage in excel

To calculate the percentage in Excel, you can use the following formula

  1. Open Microsoft Excel and create a new spreadsheet.
  2. Enter your data into the cells. In this example, input the month, sales, and target values into columns A, B, and C, respectively. Your table should look like this:
  1. Now, in cell D2, enter the formula to calculate the percentage achieved for January: = (B2 / C2) * 100
  2. Press Enter to calculate the percentage. The cell will display the result as a percentage.
  3. Drag the fill handle (a small square at the bottom-right corner of the selected cell) down to copy the formula for the remaining months (February and March). This will automatically calculate the percentages for all months.
  4. Format the cells in column D to display percentages. Select the cells D2:D4, then go to the “Home” tab, click on the “Number Format” dropdown, and choose “Percentage”.
  5. Your table should now look like this:
MonthSalesTargetPercentage Achieved

Now, your Excel table displays the sales data along with the percentage of sales achieved relative to the sales target for each month. This format provides a clear and organized view of the data, making it easy to analyze and interpret.

Check how to delete duplicate records in excel

Excel formula to calculate percentage of grand total

To calculate the percentage of each value relative to the grand total in Excel, you can use the following formula:

  1. Enter Your Data: Input your data into Excel. Let’s say you have values in column A starting from cell A2. Here’s an example:
  1. Calculate the Grand Total: In cell B2, enter the formula to sum up all the values in column A: =SUM(A2:A10)Adjust the range A2:A10 according to your data.
  2. Calculate the Percentage: In cell C2, enter the formula to calculate the percentage of each value relative to the grand total: = (A2 / $B$2) * 100This formula divides each value in column A by the grand total (B2) and multiplies by 100 to get the percentage.
  3. Create the Table: Select the range A1:C10 (or adjust the range based on your data), then go to the “Insert” tab in the Excel ribbon and click on “Table”. Ensure that “My table has headers” is checked if your data has headers.
  4. Format as Table: With your table selected, go to the “Home” tab and choose a table style from the “Styles” group. This step is optional but can make your table look more visually appealing.

Your table should now look like this:

ValueGrand TotalPercentage

Now, you have a table in Excel with the percentage of each value relative to the grand total calculated and displayed in column C. You can further customize the table and format the cells as needed to suit your preferences.

Advantages of Using Excel for Percentage Calculations

  1. Efficiency: Excel automates calculations, saving you time and effort.
  2. Accuracy: Excel handles the multiplication by 100, reducing the chance of errors.
  3. Flexibility: You can adapt formulas to various scenarios (e.g., percentage increase, percent of total, etc.).

How to Use Excel Percentage Formulas

  1. Enter Data: Input your data (e.g., quantities, amounts, etc.) into Excel.
  2. Write Formulas: Use the basic formula or variations (e.g., percentage increase).
  3. Apply Formatting: Format cells as percentages (Ctrl+Shift+% or click the “%” button on the Home tab).

Leave a Reply

Your email address will not be published. Required fields are marked *