{"id":173502,"date":"2023-12-08T10:32:00","date_gmt":"2023-12-08T10:32:00","guid":{"rendered":"https:\/\/www.henryharvin.com\/blog\/?p=173502"},"modified":"2024-12-11T12:13:52","modified_gmt":"2024-12-11T12:13:52","slug":"how-to-calculate-percentage-in-excel","status":"publish","type":"post","link":"https:\/\/www.henryharvin.com\/blog\/how-to-calculate-percentage-in-excel\/","title":{"rendered":"How to Calculate Percentages in Excel"},"content":{"rendered":"\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Are you struggling to calculate percentage every now and then? Do you need to find a calculator or mobile phone every time when it comes to the calculation of percentages? Here\u2019s a simple solution. You can calculate <a href=\"https:\/\/en.wikipedia.org\/wiki\/Percentage\" target=\"_blank\" rel=\"noreferrer noopener\">percentage <\/a>in Excel. It is a very basic task in Excel.<\/h2>\n\n\n\n<p>Eventually to find percentage of the total data the learner should know the formula to calculate percentage in Excel. In this blog, we will learn the general formula to be used in Excel sheets which can easily help calculate the percentage of the lengthy data.<\/p>\n\n\n\n<div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter size-large is-resized\"><img fetchpriority=\"high\" decoding=\"async\" src=\"https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2023\/07\/09152756\/images-1-1.jpg\" alt=\"Calculate Percentage in Excel\" class=\"wp-image-173503\" width=\"549\" height=\"289\" srcset=\"https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2023\/07\/09152756\/images-1-1.jpg 310w, https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2023\/07\/09152756\/images-1-1-300x158.jpg 300w\" sizes=\"(max-width: 549px) 100vw, 549px\" \/><\/figure><\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>1. How to Calculate Percentage in Excel<\/strong><\/h2>\n\n\n\n<p>Let us learn how to calculate the percentage in Excel using formulas with some examples additionally.Generally, the formula we use to calculate is same as in the mathematics i.e = part of work completed\/total work to be completed x 100<\/p>\n\n\n\n<p>Simultaneously, this formula can be used in Excel with nuance. <\/p>\n\n\n\n<p>Example: Let\u2019s understand improve our understanding through this example by simply calculating the percentage of travelling expenses for the year 2022.<\/p>\n\n\n\n<div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter size-large is-resized\"><img decoding=\"async\" src=\"https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2023\/07\/09155043\/formula-for-percentage-of-total-in-excel2.png\" alt=\"\" class=\"wp-image-173504\" width=\"688\" height=\"468\" srcset=\"https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2023\/07\/09155043\/formula-for-percentage-of-total-in-excel2.png 634w, https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2023\/07\/09155043\/formula-for-percentage-of-total-in-excel2-300x204.png 300w, https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2023\/07\/09155043\/formula-for-percentage-of-total-in-excel2-600x408.png 600w\" sizes=\"(max-width: 688px) 100vw, 688px\" \/><\/figure><\/div>\n\n\n\n<p>1.Firstly, we have to calculate the total amount of travelling expenses for 12 months by adding all. In Excel the formula for adding is SUM(B4:B15)<\/p>\n\n\n\n<div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter size-large is-resized\"><img decoding=\"async\" src=\"https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2023\/07\/09160305\/formula-for-percentage-of-total-in-excel3.png\" alt=\"Calculate Percentage in Excel\" class=\"wp-image-173509\" width=\"684\" height=\"465\" srcset=\"https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2023\/07\/09160305\/formula-for-percentage-of-total-in-excel3.png 634w, https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2023\/07\/09160305\/formula-for-percentage-of-total-in-excel3-300x204.png 300w, https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2023\/07\/09160305\/formula-for-percentage-of-total-in-excel3-600x408.png 600w\" sizes=\"(max-width: 684px) 100vw, 684px\" \/><\/figure><\/div>\n\n\n\n<p>2. Then the next step is to press the enter key after entering the formula<\/p>\n\n\n\n<p>3. Now, calculate the simple percentage i.e. individually and then the percentage of the first month. As with reference to the image Column C will have a simple percentage and Column D will have the result of the percentage.<\/p>\n\n\n\n<p>For the month of January, select the cell of expenses B4 dividing it by the total amount of expense which is 31200 as in cell B16 multiplied by 100.<\/p>\n\n\n\n<div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2023\/07\/09165019\/formula-for-percentage-of-total-in-excel5.png\" alt=\"Calculate Percentage in Excel\" class=\"wp-image-173519\" width=\"670\" height=\"435\" srcset=\"https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2023\/07\/09165019\/formula-for-percentage-of-total-in-excel5.png 634w, https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2023\/07\/09165019\/formula-for-percentage-of-total-in-excel5-300x195.png 300w, https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2023\/07\/09165019\/formula-for-percentage-of-total-in-excel5-600x390.png 600w\" sizes=\"(max-width: 670px) 100vw, 670px\" \/><\/figure><\/div>\n\n\n\n<p>Again after pressing the enter key, we get the January contribution to that total month. However, it is not in percentage form.<\/p>\n\n\n\n<div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2023\/07\/09165331\/formula-for-percentage-of-total-in-excel6.png\" alt=\"\" class=\"wp-image-173521\" width=\"684\" height=\"205\" srcset=\"https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2023\/07\/09165331\/formula-for-percentage-of-total-in-excel6.png 507w, https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2023\/07\/09165331\/formula-for-percentage-of-total-in-excel6-300x90.png 300w\" sizes=\"(max-width: 684px) 100vw, 684px\" \/><\/figure><\/div>\n\n\n\n<p>4. Now, use the following formula to find the percentage of a total and see how it is different from the simple percentage.Click on the enter key. As result, we can see the contribution of the month of January expenses from 12 months total (Total percentage)<\/p>\n\n\n\n<div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2023\/07\/09170622\/formula-for-percentage-of-total-in-excel7.png\" alt=\"\" class=\"wp-image-173522\" width=\"687\" height=\"445\" srcset=\"https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2023\/07\/09170622\/formula-for-percentage-of-total-in-excel7.png 583w, https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2023\/07\/09170622\/formula-for-percentage-of-total-in-excel7-300x195.png 300w\" sizes=\"(max-width: 687px) 100vw, 687px\" \/><\/figure><\/div>\n\n\n\n<p>Presently, both the values in Column C and Column D are in decimals rather than percentage. We can change it to percentage after we calculate the percentage for all 12 months.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">2. <strong>Making the denominator absolute<\/strong><\/h2>\n\n\n\n<p>So when we are willing to fix the denominator to calculate the percentage in Excel we have to use a simple formula. Additionally, we have to change the formula by adding $ in the denominator row and column as well.<\/p>\n\n\n\n<p>So when we insert $ before cell formula it will fix the percentage.<\/p>\n\n\n\n<div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2023\/07\/09172236\/formula-for-percentage-of-total-in-excel9.png\" alt=\"\" class=\"wp-image-173530\" width=\"669\" height=\"466\" srcset=\"https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2023\/07\/09172236\/formula-for-percentage-of-total-in-excel9.png 563w, https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2023\/07\/09172236\/formula-for-percentage-of-total-in-excel9-300x209.png 300w\" sizes=\"(max-width: 669px) 100vw, 669px\" \/><\/figure><\/div>\n\n\n\n<p>Here,&nbsp;<strong>$B<\/strong>&nbsp;indicates not to rewrite column and&nbsp;<strong>$16<\/strong>&nbsp;to rows consecutively. The $ sign makes the value absolute. This one is the most crucial step. So, do not skip it even by mistake.We will get the equivalent result after making the percentage formula absolute. Now, make the percentage of total formula denominator too.<\/p>\n\n\n\n<p>Thereafter we can see the plus sign that appears on the right downside of the cell. We can alternatively calculate the percentage in Excel by dragging it till the last month. Once you drag, the result will be the calculation of all the travelling expenses for 12 months.<\/p>\n\n\n\n<figure class=\"wp-block-embed aligncenter is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"Top 10 Advanced Excel Courses in India | Reviewsreporter\" width=\"720\" height=\"405\" src=\"https:\/\/www.youtube.com\/embed\/Tuh5c0jYbOk?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">3. <strong>Changing the decimals to percentage<\/strong><\/h2>\n\n\n\n<p>Currently, we can see in the image that all the percentages in Excel are in decimals for all the months. We can change it to decimal once in all. It can be done by simply selecting Columns C and D. Thereafter click on the home button in which the Percent style appears (%).<\/p>\n\n\n\n<div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2023\/07\/09182515\/formula-for-percentage-of-total-in-excel13.png\" alt=\"\" class=\"wp-image-173545\" width=\"657\" height=\"685\" srcset=\"https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2023\/07\/09182515\/formula-for-percentage-of-total-in-excel13.png 567w, https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2023\/07\/09182515\/formula-for-percentage-of-total-in-excel13-288x300.png 288w\" sizes=\"(max-width: 657px) 100vw, 657px\" \/><\/figure><\/div>\n\n\n\n<p>Once you complete the steps as mentioned above you will get the result i.e. you will get all the amount of Column C and Column D in percentage.<\/p>\n\n\n\n<div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2023\/07\/09182811\/formula-for-percentage-of-total-in-excel14.png\" alt=\"\" class=\"wp-image-173546\" width=\"680\" height=\"416\" srcset=\"https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2023\/07\/09182811\/formula-for-percentage-of-total-in-excel14.png 564w, https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2023\/07\/09182811\/formula-for-percentage-of-total-in-excel14-300x184.png 300w\" sizes=\"(max-width: 680px) 100vw, 680px\" \/><\/figure><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">4. Increase or decrease decimal values in percentage<\/h2>\n\n\n\n<p>If you want to increase or decrease decimal values in Excel as a percentage, you can utilize the &#8220;Increase Decimal&#8221; and &#8220;Decrease Decimal&#8221; buttons in conjunction with percentage formatting. Here&#8217;s how you can do it:<\/p>\n\n\n\n<p>Increase or decrease decimal values:<\/p>\n\n\n\n<p>Select the cell or range of cells containing the decimal values you want to modify.<\/p>\n\n\n\n<p>On the Ribbon, go to the &#8220;Home&#8221; tab.<\/p>\n\n\n\n<p>In the &#8220;Number&#8221; group, you&#8217;ll find the &#8220;Increase Decimal&#8221; (with a &#8220;+&#8221; sign) and &#8220;Decrease Decimal&#8221; (with a &#8220;-&#8221; sign) buttons.<\/p>\n\n\n\n<p>Click the &#8220;Increase Decimal&#8221; button to increase the number of decimal places or click the &#8220;Decrease Decimal&#8221; button to decrease the number of decimal places.<\/p>\n\n\n\n<p>Apply percentage formatting:<\/p>\n\n\n\n<p>Select the cell or range of cells with the modified decimal values.<\/p>\n\n\n\n<p>Right-click and choose &#8220;Format Cells&#8221; from the context menu.<\/p>\n\n\n\n<p>In the Format Cells dialog box, go to the &#8220;Number&#8221; tab.<\/p>\n\n\n\n<p>In the &#8220;Category&#8221; list, select &#8220;Percentage.&#8221;<\/p>\n\n\n\n<p>Specify the desired number of decimal places for the percentage if needed.<\/p>\n\n\n\n<p>Click &#8220;OK&#8221; to apply the formatting changes.<\/p>\n\n\n\n<p>By following these steps, you can increase or decrease decimal values as a percentage and format them accordingly in Excel.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Quick steps to calculate percentage in Excel:<\/h2>\n\n\n\n<p>Also check the video<\/p>\n\n\n\n\n\n<p>Here&#8217;s how you can apply this formula to calculate percentages in Excel: Determine the value you want to calculate the percentage of. Let&#8217;s assume the value is in cell A1.<\/p>\n\n\n\n<p>Identify the total or the reference value you want to use as the denominator. For example, if the total is in cell B1, use that cell as the denominator in the formula. In an empty cell, enter the formula =(A1\/B1)*100. This formula divides the value by the total and then multiplies the result by 100 to get the percentage. Press Enter to calculate the percentage. You can then copy the formula to other cells if you have additional values to calculate percentages for.<\/p>\n\n\n\n<p><strong>Remember to adjust the cell references (A1 and B1) based on your specific data arrangement.<\/strong><\/p>\n\n\n\n<p><strong>Conclusion:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>The percentage is always proportion per 100.<\/li><li>In case the learner gets the error while calculating the percentage, it can eventually remove using the IFERROR function.<\/li><li>By dividing the numerator and denominator and multiplying its result by 100 equal to percentage.<\/li><li>In Excel, the users will always get the percentage in decimal. Thereafter, it has to be changed in percentage using % in the home tab-Number.<\/li><li>Simultaneously, the user can also use a shortcut command to change data into percentage by Ctrl+Shift+%<\/li><li>Besides this, the user can also observe increase and decrease decimals to see percentage in the appropriate way.<\/li><\/ul>\n\n\n\n<p><strong>About Henry Harvin:<\/strong><\/p>\n\n\n\n<p>Henry Harvin is an unparallel institute when it comes to training and certifications. It has the Winner of the Top Corporate Training Award, Game-Based Learning Company of the Under 40 Business World Award.It provides Training + Projects + Internship + Certification + Placement + E-Learning + Masterclass + Gold Membership (all in one box).The learner can opt for the courses like <a href=\"https:\/\/www.henryharvin.com\/advanced-excel-course\" target=\"_blank\" rel=\"noreferrer noopener\">Advanced Excel Training Course<\/a>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Recommended blogs<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/www.henryharvin.com\/blog\/what-is-count-in-excel\/\" target=\"_blank\" rel=\"noreferrer noopener\">What is COUNT in Excel, and how do I use the COUNTIF function<\/a><\/li><li><a href=\"https:\/\/www.henryharvin.com\/blog\/excel-formulae-you-should-know\/\" target=\"_blank\" rel=\"noreferrer noopener\">Top 25 Microsoft Excel Formulas you should know<\/a><\/li><li><a href=\"http:\/\/Top 15 MS Excel Formulas One Must Know\" target=\"_blank\" rel=\"noreferrer noopener\">Top 15 MS Excel Formulas One Must Know<\/a><\/li><\/ul>\n\n\n\n<div class=\"schema-faq wp-block-yoast-faq-block\"><div class=\"schema-faq-section\" id=\"faq-question-1688930715839\"><strong class=\"schema-faq-question\">1. What is formula for to calculate the percentage in Excel?<\/strong> <p class=\"schema-faq-answer\">Ans.=(Part\/Total) x 100<\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1688930814475\"><strong class=\"schema-faq-question\">2. How to insert the percentage in Excel directly of the data?<\/strong> <p class=\"schema-faq-answer\">Ans. Select the data to be calculated.Then Go to Home Tab, Click on numbers and then %.<\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1688930959717\"><strong class=\"schema-faq-question\">3.What is the shortcut to calculate the percentage in Excel?<\/strong> <p class=\"schema-faq-answer\">Ans.Percentages can be calculated using the shortcut key to format a cell to contain a percentage value by\u00a0<strong>selecting the cell, then pressing CTRL+SELECT+%<\/strong>.<\/p> <\/div> <\/div>\n","protected":false},"excerpt":{"rendered":"<p>Are you struggling to calculate percentage every now and then? Do you need to find a calculator or mobile phone&#8230;<\/p>\n","protected":false},"author":1000,"featured_media":175045,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","two_page_speed":[],"footnotes":""},"categories":[19529],"tags":[],"class_list":["post-173502","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-advanced-excel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Calculate Percentage in Excel<\/title>\n<meta name=\"description\" content=\"How to Calculate Percentage in Excel-easy formulas with examples to calculate percentage in excel for data of learner.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.henryharvin.com\/blog\/how-to-calculate-percentage-in-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Calculate Percentage in Excel\" \/>\n<meta property=\"og:description\" content=\"How to Calculate Percentage in Excel-easy formulas with examples to calculate percentage in excel for data of learner.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.henryharvin.com\/blog\/how-to-calculate-percentage-in-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Henry Harvin Blog\" \/>\n<meta property=\"article:published_time\" content=\"2023-12-08T10:32:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-12-11T12:13:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2023\/07\/14124449\/pasted-image-0-2023-07-14T181427.950.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1600\" \/>\n\t<meta property=\"og:image:height\" content=\"1067\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Nikita Dharkar\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@henryharvin_in\" \/>\n<meta name=\"twitter:site\" content=\"@henryharvin_in\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Nikita Dharkar\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/how-to-calculate-percentage-in-excel\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/how-to-calculate-percentage-in-excel\\\/\"},\"author\":{\"name\":\"Nikita Dharkar\",\"@id\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/#\\\/schema\\\/person\\\/213ff9c787d81d412908232a590caab1\"},\"headline\":\"How to Calculate Percentages in Excel\",\"datePublished\":\"2023-12-08T10:32:00+00:00\",\"dateModified\":\"2024-12-11T12:13:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/how-to-calculate-percentage-in-excel\\\/\"},\"wordCount\":1237,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/#\\\/schema\\\/person\\\/a86f96dfdfc6fa224445f6b651967094\"},\"image\":{\"@id\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/how-to-calculate-percentage-in-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/hh-certificates.sgp1.digitaloceanspaces.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/07\\\/14124449\\\/pasted-image-0-2023-07-14T181427.950.png\",\"articleSection\":[\"Advanced Excel\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/how-to-calculate-percentage-in-excel\\\/#respond\"]}]},{\"@type\":[\"WebPage\",\"FAQPage\"],\"@id\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/how-to-calculate-percentage-in-excel\\\/\",\"url\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/how-to-calculate-percentage-in-excel\\\/\",\"name\":\"How to Calculate Percentage in Excel\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/how-to-calculate-percentage-in-excel\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/how-to-calculate-percentage-in-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/hh-certificates.sgp1.digitaloceanspaces.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/07\\\/14124449\\\/pasted-image-0-2023-07-14T181427.950.png\",\"datePublished\":\"2023-12-08T10:32:00+00:00\",\"dateModified\":\"2024-12-11T12:13:52+00:00\",\"description\":\"How to Calculate Percentage in Excel-easy formulas with examples to calculate percentage in excel for data of learner.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/how-to-calculate-percentage-in-excel\\\/#breadcrumb\"},\"mainEntity\":[{\"@id\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/how-to-calculate-percentage-in-excel\\\/#faq-question-1688930715839\"},{\"@id\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/how-to-calculate-percentage-in-excel\\\/#faq-question-1688930814475\"},{\"@id\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/how-to-calculate-percentage-in-excel\\\/#faq-question-1688930959717\"}],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/how-to-calculate-percentage-in-excel\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/how-to-calculate-percentage-in-excel\\\/#primaryimage\",\"url\":\"https:\\\/\\\/hh-certificates.sgp1.digitaloceanspaces.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/07\\\/14124449\\\/pasted-image-0-2023-07-14T181427.950.png\",\"contentUrl\":\"https:\\\/\\\/hh-certificates.sgp1.digitaloceanspaces.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/07\\\/14124449\\\/pasted-image-0-2023-07-14T181427.950.png\",\"width\":1600,\"height\":1067},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/how-to-calculate-percentage-in-excel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Advanced Excel\",\"item\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/category\\\/advanced-excel\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"How to Calculate Percentages in Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/\",\"name\":\"Henry Harvin Blog\",\"description\":\"Latest Online Courses &amp; Certification Blogs\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/#\\\/schema\\\/person\\\/a86f96dfdfc6fa224445f6b651967094\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/#\\\/schema\\\/person\\\/a86f96dfdfc6fa224445f6b651967094\",\"name\":\"George L V\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/hh-certificates.sgp1.digitaloceanspaces.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/01\\\/19130846\\\/cropped-Henry-harvin-logo-1.png\",\"url\":\"https:\\\/\\\/hh-certificates.sgp1.digitaloceanspaces.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/01\\\/19130846\\\/cropped-Henry-harvin-logo-1.png\",\"contentUrl\":\"https:\\\/\\\/hh-certificates.sgp1.digitaloceanspaces.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/01\\\/19130846\\\/cropped-Henry-harvin-logo-1.png\",\"width\":445,\"height\":130,\"caption\":\"George L V\"},\"logo\":{\"@id\":\"https:\\\/\\\/hh-certificates.sgp1.digitaloceanspaces.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/01\\\/19130846\\\/cropped-Henry-harvin-logo-1.png\"},\"description\":\"George is an expert communicator. As a coordinator, senior language instructor, center head and a content writer the basic requirement at the DNA level was the same \u2013 effective communication. He discovered early in life that quality of communication makes the difference between great results and mediocre outcomes. And thus, he developed his first forte: focus on the listener and tailor the message accordingly. As he progressed in his career, he realized that the most compelling stories communicate through multi-sensory messaging - a powerful combination of visual, verbal, and intuitive content.\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/#\\\/schema\\\/person\\\/213ff9c787d81d412908232a590caab1\",\"name\":\"Nikita Dharkar\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/hh-certificates.sgp1.digitaloceanspaces.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/06\\\/26152747\\\/WhatsApp-Image-2023-06-26-at-8.56.22-PM-150x150.jpeg\",\"url\":\"https:\\\/\\\/hh-certificates.sgp1.digitaloceanspaces.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/06\\\/26152747\\\/WhatsApp-Image-2023-06-26-at-8.56.22-PM-150x150.jpeg\",\"contentUrl\":\"https:\\\/\\\/hh-certificates.sgp1.digitaloceanspaces.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/06\\\/26152747\\\/WhatsApp-Image-2023-06-26-at-8.56.22-PM-150x150.jpeg\",\"caption\":\"Nikita Dharkar\"},\"url\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/author\\\/nikita-junnarkarrediffmail-com\\\/\"},{\"@type\":\"Question\",\"@id\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/how-to-calculate-percentage-in-excel\\\/#faq-question-1688930715839\",\"position\":1,\"url\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/how-to-calculate-percentage-in-excel\\\/#faq-question-1688930715839\",\"name\":\"1. What is formula for to calculate the percentage in Excel?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Ans.=(Part\\\/Total) x 100\",\"inLanguage\":\"en-US\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Question\",\"@id\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/how-to-calculate-percentage-in-excel\\\/#faq-question-1688930814475\",\"position\":2,\"url\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/how-to-calculate-percentage-in-excel\\\/#faq-question-1688930814475\",\"name\":\"2. How to insert the percentage in Excel directly of the data?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Ans. Select the data to be calculated.Then Go to Home Tab, Click on numbers and then %.\",\"inLanguage\":\"en-US\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Question\",\"@id\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/how-to-calculate-percentage-in-excel\\\/#faq-question-1688930959717\",\"position\":3,\"url\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/how-to-calculate-percentage-in-excel\\\/#faq-question-1688930959717\",\"name\":\"3.What is the shortcut to calculate the percentage in Excel?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Ans.Percentages can be calculated using the shortcut key to format a cell to contain a percentage value by\u00a0<strong>selecting the cell, then pressing CTRL+SELECT+%<\\\/strong>.\",\"inLanguage\":\"en-US\"},\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Calculate Percentage in Excel","description":"How to Calculate Percentage in Excel-easy formulas with examples to calculate percentage in excel for data of learner.","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:\/\/www.henryharvin.com\/blog\/how-to-calculate-percentage-in-excel\/","og_locale":"en_US","og_type":"article","og_title":"How to Calculate Percentage in Excel","og_description":"How to Calculate Percentage in Excel-easy formulas with examples to calculate percentage in excel for data of learner.","og_url":"https:\/\/www.henryharvin.com\/blog\/how-to-calculate-percentage-in-excel\/","og_site_name":"Henry Harvin Blog","article_published_time":"2023-12-08T10:32:00+00:00","article_modified_time":"2024-12-11T12:13:52+00:00","og_image":[{"width":1600,"height":1067,"url":"https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2023\/07\/14124449\/pasted-image-0-2023-07-14T181427.950.png","type":"image\/png"}],"author":"Nikita Dharkar","twitter_card":"summary_large_image","twitter_creator":"@henryharvin_in","twitter_site":"@henryharvin_in","twitter_misc":{"Written by":"Nikita Dharkar","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.henryharvin.com\/blog\/how-to-calculate-percentage-in-excel\/#article","isPartOf":{"@id":"https:\/\/www.henryharvin.com\/blog\/how-to-calculate-percentage-in-excel\/"},"author":{"name":"Nikita Dharkar","@id":"https:\/\/www.henryharvin.com\/blog\/#\/schema\/person\/213ff9c787d81d412908232a590caab1"},"headline":"How to Calculate Percentages in Excel","datePublished":"2023-12-08T10:32:00+00:00","dateModified":"2024-12-11T12:13:52+00:00","mainEntityOfPage":{"@id":"https:\/\/www.henryharvin.com\/blog\/how-to-calculate-percentage-in-excel\/"},"wordCount":1237,"commentCount":0,"publisher":{"@id":"https:\/\/www.henryharvin.com\/blog\/#\/schema\/person\/a86f96dfdfc6fa224445f6b651967094"},"image":{"@id":"https:\/\/www.henryharvin.com\/blog\/how-to-calculate-percentage-in-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2023\/07\/14124449\/pasted-image-0-2023-07-14T181427.950.png","articleSection":["Advanced Excel"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.henryharvin.com\/blog\/how-to-calculate-percentage-in-excel\/#respond"]}]},{"@type":["WebPage","FAQPage"],"@id":"https:\/\/www.henryharvin.com\/blog\/how-to-calculate-percentage-in-excel\/","url":"https:\/\/www.henryharvin.com\/blog\/how-to-calculate-percentage-in-excel\/","name":"How to Calculate Percentage in Excel","isPartOf":{"@id":"https:\/\/www.henryharvin.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.henryharvin.com\/blog\/how-to-calculate-percentage-in-excel\/#primaryimage"},"image":{"@id":"https:\/\/www.henryharvin.com\/blog\/how-to-calculate-percentage-in-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2023\/07\/14124449\/pasted-image-0-2023-07-14T181427.950.png","datePublished":"2023-12-08T10:32:00+00:00","dateModified":"2024-12-11T12:13:52+00:00","description":"How to Calculate Percentage in Excel-easy formulas with examples to calculate percentage in excel for data of learner.","breadcrumb":{"@id":"https:\/\/www.henryharvin.com\/blog\/how-to-calculate-percentage-in-excel\/#breadcrumb"},"mainEntity":[{"@id":"https:\/\/www.henryharvin.com\/blog\/how-to-calculate-percentage-in-excel\/#faq-question-1688930715839"},{"@id":"https:\/\/www.henryharvin.com\/blog\/how-to-calculate-percentage-in-excel\/#faq-question-1688930814475"},{"@id":"https:\/\/www.henryharvin.com\/blog\/how-to-calculate-percentage-in-excel\/#faq-question-1688930959717"}],"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.henryharvin.com\/blog\/how-to-calculate-percentage-in-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.henryharvin.com\/blog\/how-to-calculate-percentage-in-excel\/#primaryimage","url":"https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2023\/07\/14124449\/pasted-image-0-2023-07-14T181427.950.png","contentUrl":"https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2023\/07\/14124449\/pasted-image-0-2023-07-14T181427.950.png","width":1600,"height":1067},{"@type":"BreadcrumbList","@id":"https:\/\/www.henryharvin.com\/blog\/how-to-calculate-percentage-in-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.henryharvin.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Advanced Excel","item":"https:\/\/www.henryharvin.com\/blog\/category\/advanced-excel\/"},{"@type":"ListItem","position":3,"name":"How to Calculate Percentages in Excel"}]},{"@type":"WebSite","@id":"https:\/\/www.henryharvin.com\/blog\/#website","url":"https:\/\/www.henryharvin.com\/blog\/","name":"Henry Harvin Blog","description":"Latest Online Courses &amp; Certification Blogs","publisher":{"@id":"https:\/\/www.henryharvin.com\/blog\/#\/schema\/person\/a86f96dfdfc6fa224445f6b651967094"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.henryharvin.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.henryharvin.com\/blog\/#\/schema\/person\/a86f96dfdfc6fa224445f6b651967094","name":"George L V","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2025\/01\/19130846\/cropped-Henry-harvin-logo-1.png","url":"https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2025\/01\/19130846\/cropped-Henry-harvin-logo-1.png","contentUrl":"https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2025\/01\/19130846\/cropped-Henry-harvin-logo-1.png","width":445,"height":130,"caption":"George L V"},"logo":{"@id":"https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2025\/01\/19130846\/cropped-Henry-harvin-logo-1.png"},"description":"George is an expert communicator. As a coordinator, senior language instructor, center head and a content writer the basic requirement at the DNA level was the same \u2013 effective communication. He discovered early in life that quality of communication makes the difference between great results and mediocre outcomes. And thus, he developed his first forte: focus on the listener and tailor the message accordingly. As he progressed in his career, he realized that the most compelling stories communicate through multi-sensory messaging - a powerful combination of visual, verbal, and intuitive content."},{"@type":"Person","@id":"https:\/\/www.henryharvin.com\/blog\/#\/schema\/person\/213ff9c787d81d412908232a590caab1","name":"Nikita Dharkar","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2023\/06\/26152747\/WhatsApp-Image-2023-06-26-at-8.56.22-PM-150x150.jpeg","url":"https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2023\/06\/26152747\/WhatsApp-Image-2023-06-26-at-8.56.22-PM-150x150.jpeg","contentUrl":"https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2023\/06\/26152747\/WhatsApp-Image-2023-06-26-at-8.56.22-PM-150x150.jpeg","caption":"Nikita Dharkar"},"url":"https:\/\/www.henryharvin.com\/blog\/author\/nikita-junnarkarrediffmail-com\/"},{"@type":"Question","@id":"https:\/\/www.henryharvin.com\/blog\/how-to-calculate-percentage-in-excel\/#faq-question-1688930715839","position":1,"url":"https:\/\/www.henryharvin.com\/blog\/how-to-calculate-percentage-in-excel\/#faq-question-1688930715839","name":"1. What is formula for to calculate the percentage in Excel?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"Ans.=(Part\/Total) x 100","inLanguage":"en-US"},"inLanguage":"en-US"},{"@type":"Question","@id":"https:\/\/www.henryharvin.com\/blog\/how-to-calculate-percentage-in-excel\/#faq-question-1688930814475","position":2,"url":"https:\/\/www.henryharvin.com\/blog\/how-to-calculate-percentage-in-excel\/#faq-question-1688930814475","name":"2. How to insert the percentage in Excel directly of the data?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"Ans. Select the data to be calculated.Then Go to Home Tab, Click on numbers and then %.","inLanguage":"en-US"},"inLanguage":"en-US"},{"@type":"Question","@id":"https:\/\/www.henryharvin.com\/blog\/how-to-calculate-percentage-in-excel\/#faq-question-1688930959717","position":3,"url":"https:\/\/www.henryharvin.com\/blog\/how-to-calculate-percentage-in-excel\/#faq-question-1688930959717","name":"3.What is the shortcut to calculate the percentage in Excel?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"Ans.Percentages can be calculated using the shortcut key to format a cell to contain a percentage value by\u00a0<strong>selecting the cell, then pressing CTRL+SELECT+%<\/strong>.","inLanguage":"en-US"},"inLanguage":"en-US"}]}},"views":1043,"_links":{"self":[{"href":"https:\/\/www.henryharvin.com\/blog\/wp-json\/wp\/v2\/posts\/173502","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.henryharvin.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.henryharvin.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.henryharvin.com\/blog\/wp-json\/wp\/v2\/users\/1000"}],"replies":[{"embeddable":true,"href":"https:\/\/www.henryharvin.com\/blog\/wp-json\/wp\/v2\/comments?post=173502"}],"version-history":[{"count":1,"href":"https:\/\/www.henryharvin.com\/blog\/wp-json\/wp\/v2\/posts\/173502\/revisions"}],"predecessor-version":[{"id":228198,"href":"https:\/\/www.henryharvin.com\/blog\/wp-json\/wp\/v2\/posts\/173502\/revisions\/228198"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.henryharvin.com\/blog\/wp-json\/wp\/v2\/media\/175045"}],"wp:attachment":[{"href":"https:\/\/www.henryharvin.com\/blog\/wp-json\/wp\/v2\/media?parent=173502"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.henryharvin.com\/blog\/wp-json\/wp\/v2\/categories?post=173502"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.henryharvin.com\/blog\/wp-json\/wp\/v2\/tags?post=173502"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}