{"id":2835,"date":"2022-01-18T19:12:06","date_gmt":"2022-01-18T19:12:06","guid":{"rendered":"http:\/\/trucos.com\/uncategorized\/como-sacar-porcentajes-en-excel\/"},"modified":"2022-01-18T19:12:06","modified_gmt":"2022-01-18T19:12:06","slug":"how-to-get-percentages-in-excel","status":"publish","type":"post","link":"https:\/\/trucos.com\/en\/math\/how-to-get-percentages-in-excel\/","title":{"rendered":"How to get percentages in Excel"},"content":{"rendered":"<p>Let&#039;s see <strong>how to get percentages in Excel<\/strong>, the popular office automation and data management program for computers. And many users use Excel daily in their jobs, in addition to accounting for <strong>own or company invoices<\/strong>, so knowing all its tricks is essential to make the most of the tools that Excel offers. AND <strong>calculate percentages<\/strong> It is essential in many operations, whether to obtain personal income tax, <a href=\"http:\/\/trucos.com\/en\/math\/how-to-remove-vat-from-a-price\/\" target=\"_blank\" rel=\"noopener\">VAT<\/a> or any percentage of a given figure. Therefore, below we show you <strong>how to calculate percentages in Excel quickly and easily<\/strong>.<\/p>\n<div class=\"lyte-wrapper fourthree\" title=\"How to calculate percentages in Excel\" style=\"width:420px;max-width:100%;margin:5px auto;\"><div class=\"lyMe\" id=\"WYL_EPsNjZazkvI\" itemprop=\"video\" itemscope itemtype=\"https:\/\/schema.org\/VideoObject\"><div><meta itemprop=\"thumbnailUrl\" content=\"https:\/\/i.ytimg.com\/vi\/EPsNjZazkvI\/hqdefault.jpg\" \/><meta itemprop=\"embedURL\" content=\"https:\/\/www.youtube.com\/embed\/EPsNjZazkvI\" \/><meta itemprop=\"duration\" content=\"PT7M8S\" \/><meta itemprop=\"uploadDate\" content=\"2018-06-22T05:10:41Z\" \/><\/div><div id=\"lyte_EPsNjZazkvI\" data-src=\"https:\/\/i.ytimg.com\/vi\/EPsNjZazkvI\/hqdefault.jpg\" class=\"pL\"><div class=\"tC\"><div class=\"tT\" itemprop=\"name\">How to calculate percentages in Excel<\/div><\/div><div class=\"play\"><\/div><div class=\"ctrl\"><div class=\"Lctrl\"><\/div><div class=\"Rctrl\"><\/div><\/div><\/div><noscript><a href=\"https:\/\/youtu.be\/EPsNjZazkvI\" rel=\"nofollow\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/i.ytimg.com\/vi\/EPsNjZazkvI\/0.jpg\" alt=\"How to calculate percentages in Excel\" width=\"420\" height=\"295\" \/><br \/>Watch this video on YouTube<\/a><\/noscript><meta itemprop=\"description\" content=\"Para calcular porcentajes en Excel es importante recordar que dichos valores son n\u00fameros decimales entre cero y uno. Por esta raz\u00f3n, si en tu hoja de Excel tienes un n\u00famero entero mayor a 1 y le aplicas el formato de porcentaje, terminar\u00e1s con un valor multiplicado por cien. Por ejemplo, si a una celda que tenga el n\u00famero 10, le aplicamos el formato de Porcentaje, observaremos en pantalla el valor 1000%. Para ingresar el diez porciento en Excel, debemos ingresar el valor junto con el signo % o su valor decimal equivalente, que para diez por ciento ser\u00eda 0.1 CALCULAR PORCENTAJES EN EXCEL Para calcular el porcentaje de cualquier cantidad, debemos multiplicarla por el porcentaje requerido. Por ejemplo, suponiendo que queremos obtener el 25% del valor de la celda A1, la f\u00f3rmula a utilizar es la siguiente: =A1*25% Excel reconoce adecuadamente el signo % dentro de la f\u00f3rmula y hace la multiplicaci\u00f3n de manera adecuada. Si no quieres usar el signo %, entonces puede ingresar el valor decimal que equivale a 25% y que es 0.25. =A1*0.25 SUMAR PORCENTAJES EN EXCEL Para agregar un tanto porciento a una cantidad determinada, podemos hacer la multiplicaci\u00f3n por un porcentaje superior al 100%. Por ejemplo, si a una cantidad le quiero sumar el 25%, ser\u00e1 suficiente con multiplicarla por 125% y habremos a\u00f1adido el 25% al valor original. #ExcelTotal\"><\/div><\/div><div class=\"lL\" style=\"max-width:100%;width:420px;margin:5px auto;\"><\/div><\/p>\n<h2>How to calculate percentages in Excel<\/h2>\n<h3>Index of contents<\/h3>\n<ul>\n<li>\n<h3><a href=\"#como sacar\">How to get a percentage in Excel<\/a><\/h3>\n<\/li>\n<li>\n<h3><a href=\"#como averiguar\">How to find out a percentage in Excel<\/a><\/h3>\n<\/li>\n<\/ul>\n<p>In our tutorial we are going to start by explaining how to compose the <a href=\"http:\/\/trucos.com\/en\/math\/how-to-convert-from-decimal-to-hexadecimal\/\" target=\"_blank\" rel=\"noopener\">formula<\/a> for <strong>calculate the percentage of a figure<\/strong> specific; In the second section we will explain the inverse calculation, that is, how to get the percentage when the only information you have is the <strong>difference between two figures<\/strong>.<\/p>\n<h2><a id=\"como sacar\" name=\"como sacar\"><span style=\"color:#000000\">How to get a percentage in Excel<\/span><\/a><\/h2>\n<p>Thus, first we are going to find out the percentage of a specific quantity or figure, such as, for example, the 21% of 300. The first thing will be to write both figures, the total amount and the percentage that you want to get. Now, click on the box you want and write the formula detailed below to multiply the figure by the percentage. In this case, to remove the 21% from 300.<\/p>\n<p>The formula has the format <strong>=1*2<\/strong>, with 1 being the number and 2 being the percentage. With this formula you can write the numbers or write the name of the cell so that, if you change any figure, Excel will do the calculation automatically. For example, if you entered the total number in cell D2 and the percentage in cell E2, the formula would be <strong>=D2*E2<\/strong>.<\/p>\n<p>When you type the formula in the cell and press <strong>Enter<\/strong>, Excel will show the exact result. Thus, continuing with the example described, the 21% of 300 is 63. And if you change either of the two figures, either the 21% or the 300, <strong>Excel will change the result<\/strong> automatically.<\/p>\n<p><img decoding=\"async\" alt=\"How to get percentages in Excel\" src=\"\/media\/upload\/2022\/01\/18\/como-calcular-porcentaje-excel-01.jpg\" style=\"width:100%\" title=\"How to get percentages in Excel\" \/><\/p>\n<h2><a id=\"como averiguar\" name=\"como averiguar\"><span style=\"color:#000000\">How to find out a percentage in Excel<\/span><\/a><\/h2>\n<p>In this case we are going to do the reverse operation, that is, <strong>get the percentage of two figures<\/strong> known. For example, imagine that you have 50 euros and you need to spend 8 euros of the 50. What percentage will you spend? To perform the calculation you could make a rule of three; if 50 is the 100%, then 8 is X. This operation in formula <a href=\"http:\/\/trucos.com\/en\/technology\/the-9-funniest-calculator-tricks\/\" target=\"_blank\" rel=\"noopener\">math<\/a> is <strong>(7\/30)*100<\/strong>. This is the formula you must write in Excel.<\/p>\n<p>As in the previous case, you have two options to write the formula. So, if you just want to get the result you can <strong>write the formula with numbers<\/strong>. But if you want the results to be relative to the number of other cells and for Excel to update the results automatically, then you will have to <strong>write cell addresses<\/strong> corresponding to each number or figure.<\/p>\n<p><a href=\"https:\/\/www.youtube.com\/watch?v=GCHVz9fHn_k\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" alt=\"How to get percentages in Excel\" src=\"\/media\/upload\/2022\/01\/18\/yt.jpg\" style=\"width:100%\" title=\"How to get percentages in Excel\" \/><\/a><\/p>\n<h2>More calculation tricks<\/h2>\n<ul>\n<li>\n<h3><a href=\"http:\/\/trucos.com\/en\/math\/how-to-remove-vat-from-a-price\/\" target=\"_blank\" rel=\"noopener\">How to remove VAT from a price<\/a><\/h3>\n<\/li>\n<li>\n<h3><a href=\"http:\/\/trucos.com\/en\/math\/how-to-convert-from-decimal-to-hexadecimal\/\" target=\"_blank\" rel=\"noopener\">How to go from decimal to hexadecimal<\/a><\/h3>\n<\/li>\n<li>\n<h3><a href=\"http:\/\/trucos.com\/en\/computers\/how-to-know-the-inches-of-a-laptop\/\" target=\"_blank\" rel=\"noopener\">How to know the inches of a laptop<\/a><\/h3>\n<\/li>\n<\/ul>","protected":false},"excerpt":{"rendered":"<p>Do you want to get percentages quickly and easily? We teach you how to calculate percentages of figures in Microsoft Excel, the popular data management program<\/p>","protected":false},"author":2,"featured_media":2836,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[22],"tags":[46],"class_list":["post-2835","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-matematicas","tag-educacion"],"blocksy_meta":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>C\u00f3mo sacar porcentajes en Excel - Trucos.com<\/title>\n<meta name=\"description\" content=\"\u00bfQuieres sacar porcentajes r\u00e1pido y f\u00e1cil? Te ense\u00f1amos c\u00f3mo calcular porcentajes de cifras en Microsoft Excel, el popular programa de gesti\u00f3n de datos\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/trucos.com\/en\/math\/how-to-get-percentages-in-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"C\u00f3mo sacar porcentajes en Excel - Trucos.com\" \/>\n<meta property=\"og:description\" content=\"\u00bfQuieres sacar porcentajes r\u00e1pido y f\u00e1cil? Te ense\u00f1amos c\u00f3mo calcular porcentajes de cifras en Microsoft Excel, el popular programa de gesti\u00f3n de datos\" \/>\n<meta property=\"og:url\" content=\"https:\/\/trucos.com\/en\/math\/how-to-get-percentages-in-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Trucos.com\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/trucoscom\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-01-18T19:12:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/trucos.com\/wp-content\/uploads\/2023\/06\/como_calcular_porcentaje_excel_00.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"800\" \/>\n\t<meta property=\"og:image:height\" content=\"605\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Redaccion\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Redaccion\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"C\u00f3mo sacar porcentajes en Excel - Trucos.com","description":"\u00bfQuieres sacar porcentajes r\u00e1pido y f\u00e1cil? Te ense\u00f1amos c\u00f3mo calcular porcentajes de cifras en Microsoft Excel, el popular programa de gesti\u00f3n de datos","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:\/\/trucos.com\/en\/math\/how-to-get-percentages-in-excel\/","og_locale":"en_GB","og_type":"article","og_title":"C\u00f3mo sacar porcentajes en Excel - Trucos.com","og_description":"\u00bfQuieres sacar porcentajes r\u00e1pido y f\u00e1cil? Te ense\u00f1amos c\u00f3mo calcular porcentajes de cifras en Microsoft Excel, el popular programa de gesti\u00f3n de datos","og_url":"https:\/\/trucos.com\/en\/math\/how-to-get-percentages-in-excel\/","og_site_name":"Trucos.com","article_publisher":"https:\/\/www.facebook.com\/trucoscom\/","article_published_time":"2022-01-18T19:12:06+00:00","og_image":[{"width":800,"height":605,"url":"https:\/\/trucos.com\/wp-content\/uploads\/2023\/06\/como_calcular_porcentaje_excel_00.jpg","type":"image\/jpeg"}],"author":"Redaccion","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Redaccion","Estimated reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/trucos.com\/ca\/matematiques\/com-treure-percentatges-en-excel\/#article","isPartOf":{"@id":"https:\/\/trucos.com\/ca\/matematiques\/com-treure-percentatges-en-excel\/"},"author":{"name":"Redaccion","@id":"https:\/\/trucos.com\/#\/schema\/person\/a435f425aecd84e1df6f98ccee7ce536"},"headline":"C\u00f3mo sacar porcentajes en Excel","datePublished":"2022-01-18T19:12:06+00:00","mainEntityOfPage":{"@id":"https:\/\/trucos.com\/ca\/matematiques\/com-treure-percentatges-en-excel\/"},"wordCount":617,"publisher":{"@id":"https:\/\/trucos.com\/#organization"},"image":{"@id":"https:\/\/trucos.com\/ca\/matematiques\/com-treure-percentatges-en-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/trucos.com\/wp-content\/uploads\/2023\/06\/como_calcular_porcentaje_excel_00.jpg","keywords":["Educaci\u00f3n"],"articleSection":["Matem\u00e1ticas"],"inLanguage":"en-GB"},{"@type":"WebPage","@id":"https:\/\/trucos.com\/ca\/matematiques\/com-treure-percentatges-en-excel\/","url":"https:\/\/trucos.com\/ca\/matematiques\/com-treure-percentatges-en-excel\/","name":"C\u00f3mo sacar porcentajes en Excel - Trucos.com","isPartOf":{"@id":"https:\/\/trucos.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/trucos.com\/ca\/matematiques\/com-treure-percentatges-en-excel\/#primaryimage"},"image":{"@id":"https:\/\/trucos.com\/ca\/matematiques\/com-treure-percentatges-en-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/trucos.com\/wp-content\/uploads\/2023\/06\/como_calcular_porcentaje_excel_00.jpg","datePublished":"2022-01-18T19:12:06+00:00","description":"\u00bfQuieres sacar porcentajes r\u00e1pido y f\u00e1cil? Te ense\u00f1amos c\u00f3mo calcular porcentajes de cifras en Microsoft Excel, el popular programa de gesti\u00f3n de datos","breadcrumb":{"@id":"https:\/\/trucos.com\/ca\/matematiques\/com-treure-percentatges-en-excel\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/trucos.com\/ca\/matematiques\/com-treure-percentatges-en-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/trucos.com\/ca\/matematiques\/com-treure-percentatges-en-excel\/#primaryimage","url":"https:\/\/trucos.com\/wp-content\/uploads\/2023\/06\/como_calcular_porcentaje_excel_00.jpg","contentUrl":"https:\/\/trucos.com\/wp-content\/uploads\/2023\/06\/como_calcular_porcentaje_excel_00.jpg","width":800,"height":605},{"@type":"BreadcrumbList","@id":"https:\/\/trucos.com\/ca\/matematiques\/com-treure-percentatges-en-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/trucos.com\/"},{"@type":"ListItem","position":2,"name":"C\u00f3mo sacar porcentajes en Excel"}]},{"@type":"WebSite","@id":"https:\/\/trucos.com\/#website","url":"https:\/\/trucos.com\/","name":"Trucos.com","description":"Los mejores trucos sobre videojuegos, tecnolog\u00eda y m\u00f3viles","publisher":{"@id":"https:\/\/trucos.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/trucos.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/trucos.com\/#organization","name":"Trucos.com","url":"https:\/\/trucos.com\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/trucos.com\/#\/schema\/logo\/image\/","url":"https:\/\/trucos.com\/wp-content\/uploads\/2023\/06\/trucoscomlogo.png","contentUrl":"https:\/\/trucos.com\/wp-content\/uploads\/2023\/06\/trucoscomlogo.png","width":207,"height":68,"caption":"Trucos.com"},"image":{"@id":"https:\/\/trucos.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/trucoscom\/"]},{"@type":"Person","@id":"https:\/\/trucos.com\/#\/schema\/person\/a435f425aecd84e1df6f98ccee7ce536","name":"Redaccion","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/trucos.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/d9294dcdc49d94ba92a2933c1c65d27c01fed9c237bbd5f6c305ee54ff52f55b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d9294dcdc49d94ba92a2933c1c65d27c01fed9c237bbd5f6c305ee54ff52f55b?s=96&d=mm&r=g","caption":"Redaccion"},"sameAs":["http:\/\/trucos.com"],"url":"https:\/\/trucos.com\/en\/author\/redaccion\/"}]}},"_links":{"self":[{"href":"https:\/\/trucos.com\/en\/wp-json\/wp\/v2\/posts\/2835","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/trucos.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/trucos.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/trucos.com\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/trucos.com\/en\/wp-json\/wp\/v2\/comments?post=2835"}],"version-history":[{"count":0,"href":"https:\/\/trucos.com\/en\/wp-json\/wp\/v2\/posts\/2835\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/trucos.com\/en\/wp-json\/wp\/v2\/media\/2836"}],"wp:attachment":[{"href":"https:\/\/trucos.com\/en\/wp-json\/wp\/v2\/media?parent=2835"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/trucos.com\/en\/wp-json\/wp\/v2\/categories?post=2835"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/trucos.com\/en\/wp-json\/wp\/v2\/tags?post=2835"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}