Course Content

Course Content

Pct Calculation in MS Excel

How to calculate percentage in MS Excel


Now we will see that how we can calculate percentage in MS Excel.

Here we have an excel sheet in which we want to calculate percentage change as per every month.

So now if we want to calculate percentage change for our February month we can do that by using formula as, =(C4-B4)/B4 where, B4 is first month's profit and C4 is second month's profit.

Now if we want to convert that into percentage, we can go into our HOME tab and select that particular cell which we want to convert and use the percentage option from Ribbon section.

One thing which we need to remember in this that whenever we use any formula which consist of brackets, number of opening brackets should always be equal to number of closing brackets.


'=part/total is the basic formula for determining a percentage. Assume you wish to cut a specific amount by 25%, as though you're trying to apply a discount. The formula will be =Price*1-Discount percent in this case.'

Allow Excel to calculate the total of a column or row of numbers for you. Select a cell next to the numbers you wish to add, go to the Home tab, click AutoSum, and hit Enter. Excel automatically enters a formula (using the SUM function) to sum the values when you click AutoSum.

Remove the quotations from the following formula and type it into the cell: "=PERCENTILE. EXC(A1:AX,k)," where "X" is the last row in column "A" where you submitted data and "k" is the percentile value you seek.

In Excel, you may compute a % of a number by multiplying the percentage value by the number you wish to get the percentage of. For example, if you want to find 20% of 500, multiply 20% by 500.

Steps 1 through 3 can be used to obtain an anticipated due date: First, figure out when your previous menstrual period began. Next, go back three months in time from that day. Finally, subtract 1 year and 7 days from the date.

Recommended Courses

Share With Friend

Have a friend to whom you would want to share this course?

Download LearnVern App

App Preview Image
App QR Code Image
Code Scan or Download the app
Google Play Store
Apple App Store
598K+ Downloads
App Download Section Circle 1
4.57 Avg. Ratings
App Download Section Circle 2
15K+ Reviews
App Download Section Circle 3
  • Learn anywhere on the go
  • Get regular updates about your enrolled or new courses
  • Share content with your friends
  • Evaluate your progress through practice tests
  • No internet connection needed
  • Enroll for the webinar and join at the time of the webinar from anywhere