How to calculate percentage between two quantities in Excel

If you want to do some kind of calculations with percentageThe procedures to follow will be shown below:

Before performing the actual procedure, you must insert or apply the format in question, in the cell where the percentage is to be expressed. The format to be applied is decimal, so that the result of the percentage is shown exactly.

It must also be borne in mind that it will not be enough just to place the number you want and press the percentage icon which is in the home tab, since it will only perform a multiplication of the number that we place by 100.

Percentage of the difference

Compare the difference of a value with a new one.

  1. Select cell D2 / Write: = (A2-B2) / A2
  2. Select cell D2 / Apply percentage cell format with the desired decimal places.
  3. Check as a sample -100% when B2 represents 100% of A2. To show it as positive multiply the expression by -1.

Percentage of total

Calculate the percentage of one value with respect to another.

  1. Select cell E2 / Write: = A2 / B2
  2. Select cell E2 / Apply percentage cell format with the desired decimal places.
  3. Verify as a 50% sample by considering B2 as twice A2.

Percentage of variation between number

Calculate the percentage of variation between one value with respect to another.

  1. Select cell F2 / Write: = A2 / B2-1
  2. Select cell F2 / Apply percentage cell format with the desired decimal places.
  3. Check as a sample -50% when B2 is considered as twice A2 with a negative value.

Calculations in Excel

How to calculate percentage between two quantities in Excel

The Excel is one of the most useful programs, since with this tool you can do multiple calculations and use its functions that will undoubtedly facilitate the daily tasks when taking accounts. It is used for multiple tasks in different work areas, becoming the best ally of professionals who work both in financial, administrative and accounting tasks.

In this way with the data stored in Excel basic calculations can be performed, apply more complex mathematical functions and even use statistical functions, therefore it is a program that allows you to analyze the entered data in a simple and efficient way, with the help of graphs and dynamic tables.

Excel it’s a very useful program since it allows working with numbers in a simple and intuitive way.

The uses of Excel they cover both the personal and professional level. In this way, outside of work, with the help of this program you can keep the accounts up to date from home, calculate finances and even simply organize data in spreadsheets.

Excel has various functions that allow perform calculations just by entering data on the sheets giving a correct result, if a good procedure is performed. These functions of Excel They are listed for their functionality. Some of those categories are: search and reference functions, logic functions, text functions, date and time functions, among others.

It is possible that when you see the large number of tools, functions and commands available within Excel users may get confused. However, once the necessary commands are known using Excel it will be in a more efficient way.

Leave a Comment

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

Scroll to Top