In this short how-to tip, we will see how you can use a percentage formula in Excel.
Example of Excel Spreadsheet
Below, you can see an example of an Excel spreadsheet, that contains some sample values, based on which we will create a percentage formula.
As you can see, the spreadsheet has 3 columns:
- Growth Percentage
What we need to do know, is to calculate the values for the column “Growth Percentage”.
To this end, we need to find the proper percentage formula, that will be calculating the growth percentage of sales between months, based on the given scenario.
Finding the Percentage Formula
So, the percentage formula, for finding the growth percentage of sales between months, would take the sales amount for a given month and then divide this value to the sales value of the previous month. Then, the result of this division can either be manually multiplied by 100 for giving the final percentage value, or if you select the Excel cell and click on the percentage icon, Excel will do this for you.
So let’s see the below example, where we implement this logic:
As you can see in the above screenshot, for cell C2, it is not applicable to calculate the growth percentage of sales, since there is not a preceding month. Therefore, we begin by setting the formula for cell C3.
To this end, as you can see in the above screenshot, the formula is to divide the value of C3 (that is the sales of Feb-21), by the value of the previous month, that is cell B3 (sales of Jan-21).
If we apply this formula, this is what we get:
So, now you can see, that the result of the formula for C3 is 1.5, which actually means 150%.
Now, in order to set the relevant formula for the rest of the cells, we click on the little green square rectangle on our formula, and then we hold and drag the fill handle down the column over the cells where we want to copy the formula, that is in our example, up to cell C7.
Along with the above action, we click on the percentage icon on the ribbon menu, while we have select all cells between C3 and C7, and right after we click, the values are transformed to actual percentage values as per the below screenshot.
Featured Online Courses:
- A Guide on How to Start and Monetize a Successful Blog
- Introduction to Azure Database for MySQL
- Working with Python on Windows and SQL Server Databases
- Boost SQL Server Database Performance with In-Memory OLTP
- Introduction to Azure SQL Database for Beginners
- Essential SQL Server Administration Tips
- SQL Server Fundamentals – SQL Database for Beginners
- Essential SQL Server Development Tips for SQL Developers
- Introduction to Computer Programming for Beginners
- .NET Programming for Beginners – Windows Forms with C#
- Introduction to SQL Server Machine Learning Services
- SQL Server 2019: What’s New – New and Enhanced Features
- Entity Framework: Getting Started – Complete Beginners Guide
- How to Import and Export Data in SQL Server Databases
- Learn How to Install and Start Using SQL Server in 30 Mins
- How do I Create a Formula in a Microsoft Excel Spreadsheet?
- How To Fix the Issue “This device can’t use a Trusted Platform Module”
- How To Show Hidden Files in Windows 10
- How to Fix: Slow WiFi Internet Connection on Windows 10 Laptop
- How to Save a Microsoft Word Document as a PDF?
- How do you Display Code Snippets in Microsoft Word?
- How to Find your Windows OS Version and Build Number?
Rate this article:
Reference: TechHowTos.com (https://www.techhowtos.com)