{"id":443403,"date":"2022-05-07T18:00:03","date_gmt":"2022-05-07T15:00:03","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-find-a-percentage-difference-in-google-sheets\/"},"modified":"2022-05-07T18:00:03","modified_gmt":"2022-05-07T15:00:03","slug":"how-to-find-a-percentage-difference-in-google-sheets","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-find-a-percentage-difference-in-google-sheets\/","title":{"rendered":"#How to Find a Percentage Difference in Google Sheets"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_84 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a229a919aaf5\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a229a919aaf5\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-find-a-percentage-difference-in-google-sheets\/#%E2%80%9CHow_to_Find_a_Percentage_Difference_in_Google_Sheets%E2%80%9D\" >&#8220;How to Find a Percentage Difference in Google Sheets&#8221;<\/a><ul class='ez-toc-list-level-2' ><li class='ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-find-a-percentage-difference-in-google-sheets\/#Calculate_a_Percentage_Increase_or_Decrease\" >Calculate a Percentage Increase or Decrease<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-find-a-percentage-difference-in-google-sheets\/#Automatically_Format_the_Percentage\" >Automatically Format the Percentage<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-find-a-percentage-difference-in-google-sheets\/#Manually_Format_the_Percentage\" >Manually Format the Percentage<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-find-a-percentage-difference-in-google-sheets\/#Alternative_Formula_for_a_Percentage_Change\" >Alternative Formula for a Percentage Change<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h1><span class=\"ez-toc-section\" id=\"%E2%80%9CHow_to_Find_a_Percentage_Difference_in_Google_Sheets%E2%80%9D\"><\/span>&#8220;How to Find a Percentage Difference in Google Sheets&#8221;<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-731741\" data-pagespeed-lazy-srcset=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google_sheets_her_1200x675.jpg?width=398&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 400w, https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google_sheets_her_1200x675.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 1200w\" sizes=\"auto, 400w, 1200w\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google_sheets_her_1200x675.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"\" width=\"1200\" height=\"675\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>When you want to know how much your sales went up or your bills went down, you can calculate a percentage difference in Google Sheets.<\/p>\n<p>With a simple formula, you can see the percentage increase or decrease between your values. You can also format the result as a percentage or whole number, automatically or manually.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Calculate Percentage in Google Sheets<\/em><\/strong><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Calculate_a_Percentage_Increase_or_Decrease\"><\/span>Calculate a Percentage Increase or Decrease<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To calculate the <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/405548\/how-to-find-the-percentage-of-difference-between-values-in-excel\/\">difference between two values as a percentage, you\u2019ll use a basic formula. The syntax is <code>(new_value - original_value)\/original_value<\/code> or the new value minus the original value with the result divided by the original value.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Find the Percentage of Difference Between Values in Excel<\/em><\/strong><\/p>\n<p>For an example, we want to find the percentage difference in our sales from January to February. We can see that some sales went up while others went down. You would use this formula:<\/p>\n<pre>=(C2-B2)\/B2<\/pre>\n<p>The result is -0.25 or negative 25 percent. The formula accounts for decreases by placing a negative symbol in front of the result.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-796341\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/04\/Decrease-GoogleSheetsPercentageDifference.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Percentage decrease in Google Sheets\" width=\"410\" height=\"117\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>For a positive result, we\u2019ll use our next product and the same formula with updated cell references:<\/p>\n<pre>=(C3-B3)\/B3<\/pre>\n<p>This time our result is 0.08 or 8 percent.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-796340\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/04\/Increase-GoogleSheetsPercentageDifference.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Percentage increase in Google Sheets\" width=\"410\" height=\"135\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If you prefer to display your results as percentages rather than decimals, you can do this automatically with a slight change to the formula or manually using the tools in Google Sheets.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Automatically_Format_the_Percentage\"><\/span>Automatically Format the Percentage<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/777809\/basic-google-sheets-functions\/\">Google Sheets offers a handy function for converting numbers to percentages. The function is TO_PERCENT and the syntax is <code>TO_PERCENT(value)<\/code> where the argument can be a number or cell reference.<\/p>\n<p>By adding the function to the beginning of the percentage formula which becomes the value, you\u2019ll see your result automatically formatted for you.<\/p>\n<pre>=TO_PERCENT((C2-B2)\/B2)<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-796342\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/04\/ToPercentDecrease-GoogleSheetsPercentageDifference.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"\" width=\"408\" height=\"117\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Remember to place the entire original formula in parentheses when using the TO_PERCENT function.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>9 Basic Google Sheets Functions You Should Know<\/em><\/strong><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Manually_Format_the_Percentage\"><\/span>Manually Format the Percentage<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>If you\u2019ve already entered the percentage formulas into your sheet and don\u2019t want to change them, you can simply format the results as percentages.<\/p>\n<p>Select the cell(s) containing the results and do one of the following:<\/p>\n<ul>\n<li>Click the Format as Percent button in the toolbar.<\/li>\n<li>Choose \u201cPercent\u201d in the More Formats drop-down list in the toolbar.<\/li>\n<li>Select Format &gt; Number &gt; Percent in the menu.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-796343\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/04\/PercentButton-GoogleSheetsPercentageDifference.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Percent button the toolbar\" width=\"410\" height=\"155\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Alternative_Formula_for_a_Percentage_Change\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"autotoc_anchor_3\">Alternative Formula for a Percentage Change<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>There is another formula you can use that\u2019s similar to the first. This one multiplies the result by 100, thus providing you with a <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/669623\/how-to-change-and-create-custom-number-format-in-google-sheets\/\">formatted decimal number. You can use this if you don\u2019t necessarily need to display the percent symbol.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Change and Create Custom Number Format in Google Sheets<\/em><\/strong><\/p>\n<p>Using our same examples as above, you would use this formula:<\/p>\n<pre>=(C2-B2)\/B2*100<\/pre>\n<p>Now rather than showing our result as -0.25, it displays as -25.00 or negative 25 percent.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-796345\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/04\/AlternativeMultiplyDecrease-GoogleSheetsPercentageDifference.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Alternative formula for percentage decrease in Google Sheets\" width=\"410\" height=\"117\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>The same works for our second example giving us a positive result of 8.00 or 8 percent.<\/p>\n<pre>=(C3-B3)\/B3*100<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-796344\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/04\/AlternativeMultiplyIncrease-GoogleSheetsPercentageDifference.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Alternative formula for percentage increase in Google Sheets\" width=\"410\" height=\"140\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Calculating the percentage difference between your values can give you a quick and clear picture of how numbers change.\u00a0For more, take a look at how to make negative numbers red in Google Sheets.<\/p>\n<\/div>\n<p><script>\n setTimeout(function(){\n  !function(f,b,e,v,n,t,s)\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\n  n.queue=[];t=b.createElement(e);t.async=!0;\n  t.src=v;s=b.getElementsByTagName(e)[0];\n  s.parentNode.insertBefore(t,s) } (window, document,'script',\n  'https:\/\/connect.facebook.net\/en_US\/fbevents.js');\n   fbq('init', '335401813750447');\n   fbq('track', 'PageView');\n  },3000);\n<\/script><\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/796326\/google-sheets-percentage-difference\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;How to Find a Percentage Difference in Google Sheets&#8221; When you want to know how much your sales went up or your bills went down, you can calculate a percentage difference in Google Sheets. With a simple formula, you can see the percentage increase or decrease between your values. You can also format the result&#8230;<\/p>\n","protected":false},"author":1,"featured_media":443404,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google_sheets_her_1200x675.jpg?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-443403","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/443403","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=443403"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/443403\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/443404"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=443403"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=443403"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=443403"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}