• Uncategorised

How to calculate percentages in Excel

Turning data into percentages can give you a new insight, or make summarising heaps of data that bit easier. Calculating percentages is easy with a calculator, but it’s even easier if you have a tool to automatically calculate percentages for you. This is where the percentage formula in Excel can give you the answer you need in seconds.

Here’s how to calculate percentages in Excel.

What is the formula to calculate percentage?

There are various formulas you can use to calculate a percentage. Here are two of the most common methods. Step 1: In this specific example, I’ll be calculating the difference between the profit and revenue.

Click the cell you want the percentage to appear within. Now type in =(B2-C2)/B2. The / represents the division function.

Step 2: Press the Enter key on your keyboard in order to confirm the formula.

Step 3: In the toolbar, click the percentage icon. In my example, there’s a 65% difference between the profit and revenue. If I change the profit amount to a higher figure, that percentage will decline.

How to calculate percentages in Excel

Step 4: Another formula you can use to calculate percentage is simply applying the / key in between two cells.

For example, to pass a driving theory test, I need to get 80% of the questions correct. To find out the percentage for this specific question, I’ve entered =B2/C2.

How to calculate percentages in Excel

What is the easiest way to find percentages?

Now that we’ve explained how to calculate percentages, let’s take a look at the easiest way to find percentages via the drag feature. Step 1: Click the cell where you’ve entered the formula to calculate a percentage.

Step 2: On the bottom-right corner of that cell, drag it down to where your column ends, or wherever you want percentages to be shown. In my example, I’ve dragged it down to reveal the difference between the percentage of profit being generated compared to the revenue for each month that’s listed within my spreadsheet.

How to calculate percentages in Excel

How do I find 10% of a number in Excel?

Finding a specific percentage of a number within your spreadsheet can be achieved via a straightforward formula. Step 1: Click the cell you want to find the percentage of a number in.

Step 2: Now enter, for example, =10%50. The asterisk in this formula represents the multiplication function. Press *Enter on your keyboard to confirm the result.

How to calculate percentages in Excel

Step 3: I’ve applied this same formula on my main Excel profit versus revenue spreadsheet as well.

Just replace the number 50 with the cell number where the figure is located.

How to calculate percentages in Excel

For more on Excel’s other functions, check out our guides on how to use concatenate, and how to use IF in Excel.

You can also see what’s new in Microsoft Office.

Editors’ Recommendations

Tags:

argus-car-hire listed on couponmatrix.ukebookers listed on couponmatrix.ukeleonora-bonucci listed on couponmatrix.ukgala-bingo listed on couponmatrix.ukkally-sleep listed on couponmatrix.ukvrbo listed on couponmatrix.uk
argus-car-hire listed on couponmatrix.ukArgus Car Hire make hiring vehicles in the UK, continental Europe and virtually any other major destination in the world an absolute doddle. By aggregating every hire business of any note onto one, easy-to-use website they can provide you with a car to suit your needs at the lowest price possible with a just a few clicks of your mouse. What's more, you can use the Argus Car Hire discount code to drive prices even lower, enjoying easy, low-cost motoring all over the world.
ebookers listed on couponmatrix.ukIf you fancy jetting away to a far-flung location or want to book a domestic hotel, look no further than eBookers. With a choice of thousands of hotels and hundreds of airlines and destinations, you can piece together your ideal holiday. Whether you’re looking for a five-star luxury break, or a cheap and cheerful hostel stay, eBookers will have something for you. What’s more, thanks to your eBookers discount code, you can enjoy their whole offering at the best possible prices!
eleonora-bonucci listed on couponmatrix.ukLooking for an Eleonora Bonucci promo code? You've come to the right place! Check out our exclusive deals and discounts on all your favourite Eleonora Bonucci fashion, beauty and home products. Whether you're looking for a new outfit or just some stylish accessories, we've got you covered. There’s a wide range of products, from incredible high quality tops to different scents of perfumes, so browse our selection and take advantage of our great deals today! At Groupon, we know that saving money is important to our customers and latest trends can get expensive. That's why we work hard to find the best Eleonora Bonucci promo codes and discounts codes, so you can shop for your favourite products without breaking the bank. Whether you're looking for a new outfit, home accessories or just some stylish footwear, we've got you covered. So what are you waiting for? Happy shopping! Our top-performing Eleonora Bonucci products is their clothing range. From the most beautiful coats for winter to colourful and fun swimwear for summer in a variety of different styles and colours, you’re guaranteed to get the most stylish pieces for every season. So what are you waiting for? Look stylish no matter the weather and order your best quality pieces today. And with our Eleonora Bonucci discount code, you can save even more.
gala-bingo listed on couponmatrix.ukBingo is more than a game, evidence has shown it can improve your health, make you more sociable and can even speed up the healing process. With so many benefits you’d be crazy not to check out Gala Bingo. On their site you’ll find bingo games, slot games, casino games and when you use a Gala Bingo promo code you’ll find things like free plays and other offers.
kally-sleep listed on couponmatrix.ukLet your tumultuous nights become a thing of the past with Kally Sleep, the pillow and bedding experts who design specialist sleeping aids to address everything from pregnancy to sports recovery. With an inventory capable of tackling any sleep disruption you may have, all you’ll need is a Kally Sleep discount code to get yourself well-rested on a budget. Regardless of if you suffer back pain, anxiety or sleep awkwardly, trust Kally Sleep to provide the solution.
vrbo listed on couponmatrix.ukWhen it comes to picture-perfect accommodation, there are few suppliers with a greater variety and quality to choose from than that of Vrbo. Offering cottages, houses and villas in regions ranging from the sunny shores of the Caribbean to the temperate charm of Iceland. Wherever you travel, a Vrbo discount code is an easy way to ensure you’re getting the best holiday homes available at the lowest possible price.