So, for getting the values and for absolute comparison, we need to convert the percentage into values first, subtract them and again convert them into percentage to get the exact difference even if it is as a percentage.Ģ. We can see that simply subtracting the percentage can be done but that doesn’t give any valuable information as we won’t be able to get the exact value but we can compare the performance on the basis of percentage. MARKS OF STUDENT A IN PERCENTAGE: (45/50)x100=90% Let us convert the percentage of the individual students first. Student A secured 45 marks out of 50 marks whereas Student b secured 85 marks out of 100 marks.īoth of the students study in two different schools and the Maximum Marks are different for both the students. Let us compare the marks of two students, STUDENT A and STUDENT B. Let us check this out with the help of an example. If we try to subtract the percentage which are based on the different spans or different UPPER VALUE/MAXIMUM VALUE/WHOLE, we can not simply subtract the percentage else it’ll give wrong information or result. WHEN THE TOTAL VALUE OR DENOMINATOR ARE DIFFERENT FOR THE TWO PERCENTAGE We put 23% as first percentage in first cell and 5% as second percentage in Second cell and simply subtract them in the Result cell. =CELL CONTAINING FIRST PERCENTAGE – CELL CONTAINING SECOND PERCENTAGE or First percentage value – second percentage value. In Excel, we can use this by putting the formulas as The percentage difference will be PERCENTAGE OF STUDENT A – PERCENTAGE OF STUDENT B i.e. So, if the student A has got 95 marks i.e. This case means that we are comparing two different values on the same scales.įor example, comparing the marks of the students in a class. SUBTRACTING THE PERCENTAGE WHEN THE SPAN OR TOTAL VALUE OR DENOMINATOR ARE SAME When the Total Value or Denominator are different for the two percentages.When the Total Value or Denominator is same for the two percentages.We’ll have two kind of cases while subtracting the percentages in Excel. We can not quantify the percentage difference unless and until the maximum value of both the percentages are same. NET PERCENTAGE = ONE PERCENTAGE -SECOND PERCENTAGEīut does it portray a true difference or could you find out the actual difference on the basis of this subtraction? It is just like simple basic subtraction. We can simply subtract one percentage from the other as shown below. 80-10% of 80.ġ.SUBTRACTING ONE PERCENTAGE FROM THE OTHER Subtracting a percentage of something from a value.Subtracting one percentage from the other.Subtracting percentage can have two meanings. We’ll be using these terms frequently now onwards. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |