{"id":184331,"date":"2024-04-23T05:30:00","date_gmt":"2024-04-23T04:30:00","guid":{"rendered":"https:\/\/datascientest.com\/en\/?p=184331"},"modified":"2024-04-22T19:37:24","modified_gmt":"2024-04-22T18:37:24","slug":"calculating-a-percentage-in-excel","status":"publish","type":"post","link":"https:\/\/datascientest.com\/en\/calculating-a-percentage-in-excel","title":{"rendered":"How to calculate a percentage in Excel ?"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"184331\" class=\"elementor elementor-184331\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-41bd826 e-flex e-con-boxed e-con\" data-id=\"41bd826\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-32ffa1a elementor-widget elementor-widget-heading\" data-id=\"32ffa1a\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h2 class=\"elementor-heading-title elementor-size-default\">Percentages in Excel are like a compass in a sea of data: they transform figures with no context into a means of comparison and understanding of a specific situation. Percentages offer a straightforward method for illustrating relationships between numbers, useful for tasks like calculating price fluctuations, determining proportions, analyzing financial outcomes, or evaluating performance. This clear approach helps present numerical connections effectively.<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d048117 elementor-widget elementor-widget-text-editor\" data-id=\"d048117\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p><span style=\"font-weight: 400;\">By mastering the calculation of a percentage within your data tables, you enhance your understanding of data and your efficiency. In this article, discover the complete process of <\/span><b>calculating a percentage in Excel<\/b><span style=\"font-weight: 400;\">.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d7d48b8 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"d7d48b8\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/en\/power-bi-training\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Discover our Power BI Course<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-49254c6 e-flex e-con-boxed e-con\" data-id=\"49254c6\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-799b273 elementor-widget elementor-widget-heading\" data-id=\"799b273\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">What is the formula for calculating a percentage?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b415f5f elementor-widget elementor-widget-text-editor\" data-id=\"b415f5f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">As a reminder, a percentage is a <\/span><b>proportion expressed on a basis of 100 units<\/b><span style=\"font-weight: 400;\">. The formula to determine a percentage is as follows: <\/span><b>(Partial Value\/Total Value)\u00d7100<\/b><span style=\"font-weight: 400;\">. This formula converts the ratio of the partial value over the total value into a percentage, offering a clear perspective on the relative importance of that partial value.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-312630e elementor-widget elementor-widget-heading\" data-id=\"312630e\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-medium\">Example of percentage calculation<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-794443c elementor-widget elementor-widget-text-editor\" data-id=\"794443c\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Let&#8217;s take a concrete example to illustrate what a percentage is, using the formula seen above: (partial value\/total value) x 100.<\/span><\/p><p><span style=\"font-weight: 400;\">Imagine you want to calculate the proportion of girls in a second-grade primary class. In this class of 31 students, 17 are girls.<\/span><\/p><p><span style=\"font-weight: 400;\">The partial value is then the number of girls, which is 17.<\/span><\/p><p><span style=\"font-weight: 400;\">The total value corresponds to the number of students, which is 31.<\/span><\/p><p><span style=\"font-weight: 400;\">By applying the formula, we get:<\/span><\/p><p><span style=\"font-weight: 400;\">\u2192 (17\/31) x 100 = 54.8 %<\/span><\/p><p><span style=\"font-weight: 400;\">This means that 54.8 % of the students in the class are girls. This proportion then allows you to compare with other classes that have more or less students. Indeed, 17 girls in a class of 26 students results in a higher percentage (65.4 %).<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7dd8101 elementor-widget elementor-widget-image\" data-id=\"7dd8101\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-image{text-align:center}.elementor-widget-image a{display:inline-block}.elementor-widget-image a img[src$=\".svg\"]{width:48px}.elementor-widget-image img{vertical-align:middle;display:inline-block}<\/style>\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"800\" height=\"457\" src=\"https:\/\/datascientest.com\/en\/files\/2024\/04\/calculating_percentage_Excel1.jpg\" class=\"attachment-large size-large wp-image-184334\" alt=\"\" srcset=\"https:\/\/datascientest.com\/en\/files\/2024\/04\/calculating_percentage_Excel1.jpg 875w, https:\/\/datascientest.com\/en\/files\/2024\/04\/calculating_percentage_Excel1-300x171.jpg 300w, https:\/\/datascientest.com\/en\/files\/2024\/04\/calculating_percentage_Excel1-768x439.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-2d049f1 e-flex e-con-boxed e-con\" data-id=\"2d049f1\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-61889fe elementor-widget elementor-widget-heading\" data-id=\"61889fe\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Calculating a percentage in Excel<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6f23769 elementor-widget elementor-widget-text-editor\" data-id=\"6f23769\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Let&#8217;s go back to our previous example to illustrate the application of the percentage formula in Excel. We assume then that you want to calculate the percentage of girls with respect to the total class of the second grade primary. The formula in Excel would be something like this:<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Enter the partial value in a cell (for example, B2 = 17).<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Enter the total value in another cell (for example, B3 = 31).<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">In a new cell, apply the percentage formula: =(B2\/B3)*100. You can also format this cell as &#8220;Percentage&#8221; so that Excel automatically displays the result in percentage form without needing to multiply by 100.<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7af669a elementor-widget elementor-widget-text-editor\" data-id=\"7af669a\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">The displayed result will be 54.8%, indicating that girls represent 54.8% of the second-grade primary class. If you wish, you can create a chart to make the result more visual.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a1ba13e elementor-widget elementor-widget-heading\" data-id=\"a1ba13e\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-medium\">Calculation if you know the partial value and the percentage<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-53e86f9 elementor-widget elementor-widget-text-editor\" data-id=\"53e86f9\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">If you know the number of girls in the class and the percentage of girls, but you want to know the total number of students, the calculation is as follows:<\/span><\/p><ol><li><span style=\"font-weight: 400;\">Enter the partial value in a cell (for example, B2 = 17)<\/span><\/li><li><span style=\"font-weight: 400;\">Enter the percentage in another cell (for example, B3 = 54.8%). Here, make sure to format the cell as a percentage. Otherwise, Excel will understand that your data is the number 54.8.<\/span><\/li><li><span style=\"font-weight: 400;\">In a new cell, enter the formula: =(B2\/B3). The format of the result should be numeric since you are looking for the total number of students.<\/span><\/li><\/ol>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-80febfa elementor-widget elementor-widget-text-editor\" data-id=\"80febfa\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">The number displayed will then be 31 students.<\/span><\/p><p><span style=\"font-weight: 400;\">If you know the total value and the percentage but want to know the partial value (the number of girls in the class), enter the total value in cell B2. The formula will then be a multiplication: =(B2*B3). The result will be 17.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-92ec834 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"92ec834\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/en\/power-bi-training\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Create interactive dashboards<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-323f8b9 e-flex e-con-boxed e-con\" data-id=\"323f8b9\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-dc4a037 elementor-widget elementor-widget-heading\" data-id=\"dc4a037\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Calculating a rate of change in Excel<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a98e5b7 elementor-widget elementor-widget-text-editor\" data-id=\"a98e5b7\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Now that we&#8217;ve seen how to calculate a simple percentage in Excel, it&#8217;s time to consider rates of change. Indeed, percentages are particularly relevant for testifying to an evolution, whether upward or downward. For the number of employees, turnover, costs, or even the evolution of your salary, the rate of change is an important calculation to know. And Excel simplifies the process.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-74050e5 elementor-widget elementor-widget-heading\" data-id=\"74050e5\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-medium\">Calculation of a percentage increase<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-38129b0 elementor-widget elementor-widget-text-editor\" data-id=\"38129b0\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">To calculate the increase in percentage between two values, you can use the following formula: =((Final Value &#8211; Initial Value) \/ Initial Value) * 100.<\/span><\/p><p><span style=\"text-decoration: underline;\"><b>Example<\/b><\/span><span style=\"font-weight: 400;\">: imagine you want to calculate the percentage increase in sales from one year to the next, going from 1000 units to 1200 units.<\/span><\/p><ol><li><span style=\"font-weight: 400;\">Initial value: enter the initial value in a cell, say A1 (1000).<\/span><\/li><li><span style=\"font-weight: 400;\">Final value: enter the final value in the following cell, A2 (1200).<\/span><\/li><li><span style=\"font-weight: 400;\">In a new cell, enter the formula =((A2-A1)\/A1)*100.<\/span><\/li><li><span style=\"font-weight: 400;\">Excel will display the increase in percentage. In this example, the result is 20%.<\/span><\/li><\/ol>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-199f3b8 elementor-widget elementor-widget-image\" data-id=\"199f3b8\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"800\" height=\"457\" src=\"https:\/\/datascientest.com\/en\/files\/2024\/04\/calculating_percentage_Excel2.jpg\" class=\"attachment-large size-large wp-image-184347\" alt=\"\" srcset=\"https:\/\/datascientest.com\/en\/files\/2024\/04\/calculating_percentage_Excel2.jpg 875w, https:\/\/datascientest.com\/en\/files\/2024\/04\/calculating_percentage_Excel2-300x171.jpg 300w, https:\/\/datascientest.com\/en\/files\/2024\/04\/calculating_percentage_Excel2-768x439.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4475469 elementor-widget elementor-widget-heading\" data-id=\"4475469\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-medium\">Calculation of a percentage decrease<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5c53031 elementor-widget elementor-widget-text-editor\" data-id=\"5c53031\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">To calculate a decrease in percentage, a similar logic is followed, using the formula =((Initial Value &#8211; Final Value) \/ Initial Value) * 100.<\/span><\/p><p><span style=\"text-decoration: underline;\"><b>Example<\/b><\/span><span style=\"font-weight: 400;\">: to calculate the percentage decrease of the costs of an initial project of 5000 euros that has been reduced to 4500 euros.<\/span><\/p><ol><li><span style=\"font-weight: 400;\">Initial value: enter 5000 in a cell, for instance B1.<\/span><\/li><li><span style=\"font-weight: 400;\">Final value: then enter 4500 in cell B2.<\/span><\/li><li><span style=\"font-weight: 400;\">In the cell where you want to see the result, enter =((B1-B2)\/B1)*100.<\/span><\/li><li><span style=\"font-weight: 400;\">Excel will show the reduction in percentage, here 10%.<\/span><\/li><\/ol>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3fd64ef elementor-widget elementor-widget-text-editor\" data-id=\"3fd64ef\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Before applying these formulas, make sure that the result cell is formatted as a percentage to facilitate the reading and interpretation of the results. Your result might appear as: -0.01000. To change this, <\/span><b>click on &#8220;%&#8221; in the &#8220;Home&#8221; tab<\/b><span style=\"font-weight: 400;\">. Also remember that a positive value indicates an increase, while a negative value means a reduction. These small details are important for the correct analysis of data.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-8fc0cfb e-flex e-con-boxed e-con\" data-id=\"8fc0cfb\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-ab8a2e7 elementor-widget elementor-widget-heading\" data-id=\"ab8a2e7\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Summarizing percentage calculation in Excel<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5cde93f elementor-widget elementor-widget-text-editor\" data-id=\"5cde93f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">The basic formula (Partial Value\/Total Value)\u00d7100 enables the calculation of simple percentages. For increases and decreases, we use the rate of change formula: ((Final Value &#8211; Initial Value) \/ Initial Value) * 100. To learn to create interactive dashboards and offer yourself new career opportunities, follow our <a href=\"https:\/\/datascientest.com\/en\/power-bi-training\">Power BI course<\/a>.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e9e6930 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"e9e6930\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"\/formation-power-bi\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Find out more about our Power BI training<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6e8519f elementor-widget elementor-widget-html\" data-id=\"6e8519f\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<script type=\"application\/ld+json\">\r\n{\r\n  \"@context\": \"https:\/\/schema.org\",\r\n  \"@type\": \"FAQPage\",\r\n  \"mainEntity\": [{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"What is a percentage used for in Excel?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Percentages in Excel are like a compass in a sea of data: they transform figures with no context into a means of comparison and understanding of a specific situation. Percentages offer a straightforward method for illustrating relationships between numbers, useful for tasks like calculating price fluctuations, determining proportions, analyzing financial outcomes, or evaluating performance. This clear approach helps present numerical connections effectively.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"What is the formula for calculating a percentage?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"As a reminder, a percentage is a proportion expressed on a basis of 100 units. The formula to determine a percentage is as follows: (Partial Value\/Total Value)\u00d7100. This formula converts the ratio of the partial value over the total value into a percentage, offering a clear perspective on the relative importance of that partial value.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"How do I calculate a growth rate in Excel?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"\\n Calculation of a percentage increase: To calculate the increase in percentage between two values, you can use the following formula: =((Final Value - Initial Value) \/ Initial Value) * 100. \\n Calculation of a percentage decrease: To calculate a decrease in percentage, a similar logic is followed, using the formula =((Initial Value - Final Value) \/ Initial Value) * 100.\"\r\n    }\r\n  }]\r\n}\r\n<\/script>\r\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Percentages in Excel are like a compass in a sea of data: they transform figures with no context into a means of comparison and understanding of a specific situation. Percentages offer a straightforward method for illustrating relationships between numbers, useful for tasks like calculating price fluctuations, determining proportions, analyzing financial outcomes, or evaluating performance. This [&hellip;]<\/p>\n","protected":false},"author":45,"featured_media":184333,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2420],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v21.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to calculate a percentage in Excel ?<\/title>\n<meta name=\"description\" content=\"Percentages in Excel are like a compass in a sea of data: they transform contextless numbers into a means of comparison and insight.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/datascientest.com\/en\/calculating-a-percentage-in-excel\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to calculate a percentage in Excel ?\" \/>\n<meta property=\"og:description\" content=\"Percentages in Excel are like a compass in a sea of data: they transform figures with no context into a means of comparison and understanding of a\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/en\/calculating-a-percentage-in-excel\" \/>\n<meta property=\"og:site_name\" content=\"Data Science Courses | DataScientest\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataScientestEN\" \/>\n<meta property=\"article:published_time\" content=\"2024-04-23T04:30:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-22T18:37:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/en\/files\/2024\/04\/calculating_percentage_Excel.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"686\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Daniel\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:site\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Daniel\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/datascientest.com\/en\/calculating-a-percentage-in-excel#article\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/calculating-a-percentage-in-excel\"},\"author\":{\"name\":\"Daniel\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/5a86e30c5090234fb43dd8baa83c44b0\"},\"headline\":\"How to calculate a percentage in Excel ?\",\"datePublished\":\"2024-04-23T04:30:00+00:00\",\"dateModified\":\"2024-04-22T18:37:24+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/datascientest.com\/en\/calculating-a-percentage-in-excel\"},\"wordCount\":953,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"articleSection\":[\"Business Intelligence\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/datascientest.com\/en\/calculating-a-percentage-in-excel#respond\"]}],\"copyrightYear\":\"2024\",\"copyrightHolder\":{\"@id\":\"https:\/\/datascientest.com\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/en\/calculating-a-percentage-in-excel\",\"url\":\"https:\/\/datascientest.com\/en\/calculating-a-percentage-in-excel\",\"name\":\"How to calculate a percentage in Excel ?\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/#website\"},\"datePublished\":\"2024-04-23T04:30:00+00:00\",\"dateModified\":\"2024-04-22T18:37:24+00:00\",\"description\":\"Percentages in Excel are like a compass in a sea of data: they transform contextless numbers into a means of comparison and insight.\",\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/en\/calculating-a-percentage-in-excel\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/en\/#website\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"name\":\"Data Science Courses | DataScientest\",\"description\":\"Leader in Data Science Courses\",\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/en\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/datascientest.com\/en\/#organization\",\"name\":\"DataScientest\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"contentUrl\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"width\":301,\"height\":301,\"caption\":\"DataScientest\"},\"image\":{\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/DataScientestEN\",\"https:\/\/twitter.com\/DataScientest__\",\"https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/\",\"https:\/\/www.tiktok.com\/@datascientest\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/5a86e30c5090234fb43dd8baa83c44b0\",\"name\":\"Daniel\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/837acad4f2dc47e85d81cce837261670?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/837acad4f2dc47e85d81cce837261670?s=96&d=mm&r=g\",\"caption\":\"Daniel\"},\"sameAs\":[\"https:\/\/www.linkedin.com\/school\/datascientest\/\",\"user\"],\"jobTitle\":\"ing\u00e9nieur logiciel\",\"worksFor\":\"DataScientest\",\"url\":\"https:\/\/datascientest.com\/en\/author\/team-redac\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to calculate a percentage in Excel ?","description":"Percentages in Excel are like a compass in a sea of data: they transform contextless numbers into a means of comparison and insight.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/datascientest.com\/en\/calculating-a-percentage-in-excel","og_locale":"en_GB","og_type":"article","og_title":"How to calculate a percentage in Excel ?","og_description":"Percentages in Excel are like a compass in a sea of data: they transform figures with no context into a means of comparison and understanding of a","og_url":"https:\/\/datascientest.com\/en\/calculating-a-percentage-in-excel","og_site_name":"Data Science Courses | DataScientest","article_publisher":"https:\/\/www.facebook.com\/DataScientestEN","article_published_time":"2024-04-23T04:30:00+00:00","article_modified_time":"2024-04-22T18:37:24+00:00","og_image":[{"width":1200,"height":686,"url":"https:\/\/datascientest.com\/en\/files\/2024\/04\/calculating_percentage_Excel.jpg","type":"image\/jpeg"}],"author":"Daniel","twitter_card":"summary_large_image","twitter_creator":"@DataScientest__","twitter_site":"@DataScientest__","twitter_misc":{"Written by":"Daniel","Estimated reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/datascientest.com\/en\/calculating-a-percentage-in-excel#article","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/calculating-a-percentage-in-excel"},"author":{"name":"Daniel","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/5a86e30c5090234fb43dd8baa83c44b0"},"headline":"How to calculate a percentage in Excel ?","datePublished":"2024-04-23T04:30:00+00:00","dateModified":"2024-04-22T18:37:24+00:00","mainEntityOfPage":{"@id":"https:\/\/datascientest.com\/en\/calculating-a-percentage-in-excel"},"wordCount":953,"commentCount":0,"publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"articleSection":["Business Intelligence"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/datascientest.com\/en\/calculating-a-percentage-in-excel#respond"]}],"copyrightYear":"2024","copyrightHolder":{"@id":"https:\/\/datascientest.com\/#organization"}},{"@type":"WebPage","@id":"https:\/\/datascientest.com\/en\/calculating-a-percentage-in-excel","url":"https:\/\/datascientest.com\/en\/calculating-a-percentage-in-excel","name":"How to calculate a percentage in Excel ?","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/#website"},"datePublished":"2024-04-23T04:30:00+00:00","dateModified":"2024-04-22T18:37:24+00:00","description":"Percentages in Excel are like a compass in a sea of data: they transform contextless numbers into a means of comparison and insight.","inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/en\/calculating-a-percentage-in-excel"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/en\/#website","url":"https:\/\/datascientest.com\/en\/","name":"Data Science Courses | DataScientest","description":"Leader in Data Science Courses","publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/en\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/datascientest.com\/en\/#organization","name":"DataScientest","url":"https:\/\/datascientest.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","contentUrl":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","width":301,"height":301,"caption":"DataScientest"},"image":{"@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataScientestEN","https:\/\/twitter.com\/DataScientest__","https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/","https:\/\/www.tiktok.com\/@datascientest"]},{"@type":"Person","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/5a86e30c5090234fb43dd8baa83c44b0","name":"Daniel","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/837acad4f2dc47e85d81cce837261670?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/837acad4f2dc47e85d81cce837261670?s=96&d=mm&r=g","caption":"Daniel"},"sameAs":["https:\/\/www.linkedin.com\/school\/datascientest\/","user"],"jobTitle":"ing\u00e9nieur logiciel","worksFor":"DataScientest","url":"https:\/\/datascientest.com\/en\/author\/team-redac"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/184331"}],"collection":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/users\/45"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/comments?post=184331"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/184331\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media\/184333"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media?parent=184331"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/categories?post=184331"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/tags?post=184331"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}