# Calculate Percentage Excel

This topic has been explained in great detail in the video shown below, to learn this topic just play the video and the notes are mentioned below the video.

# How to Calculate Percentage in Excel

The Video above explains how to calculate percentage in  MS Excel. The Text below is from a Microsoft Excel Support Blog
Sometimes percentages can be frustrating because it’s not always easy to remember what we learned about them in school. Let Excel do the work for you – simple formulas can help you find the percentage of a total, for example, or the percentage difference between two numbers.
And if you need to multiply by a percentage, we can help you with that too.

## Find the percentage of a total

Say that your company sold \$125,000 this quarter, and you need to find out what percentage \$20,000 is of the total.

1. To find out, divide \$20,000 by \$125,000. Here’s the formula in cell C2: =B2/A2. The result is shown as 0.16 because cell C2 is not formatted as a percentage. 2. To format 0.16 as a percentage, (which will also remove the zero) on the Home tab, click the Percentage button. Now we see that \$20,000 is 16% of \$125,000. TIP:  Formatting is the key to getting answers shown in percentages. Find out more in displaying numbers as percentages.

## Find the percentage of change between two numbers

A company sold \$485,000 in 2011 and \$598,634 in 2012. What’s the percent change between the two years?

1. First, click in cell B3 to apply the Percentage format to the cell. On the Home tab, click the Percentage button.
2. In cell B3, divide the second year’s sales (\$598,634.00) by the first year (\$485,000.00), and then subtract 1. 1. Here’s the formula in cell C3. =(B2/A2)-1. The percentage of change between the two years is 23%.

Notice the parentheses around (B2/A2). Excel calculates what’s in parentheses first, and then subtracts the 1.

# Our Other Services

myeboook.com

Myebook has 1000's of free ebooks for you. On productivity, health, online income, learning, music and many more, it's free of course!

myelesson.org/product

Become an Excel Guru, Buy the best Excel course. Learn on your mobile, tv & laptop without internet. For COD, Call 9752003788

### Create Best Looking Resume

http://www.makecv.org/

At Makecv.org you get to create a amazingly professional looking resume in just 3 steps with our intuitive resume builder!