{"id":3188,"date":"2024-08-24T05:53:11","date_gmt":"2024-08-24T07:53:11","guid":{"rendered":"https:\/\/rosybrown-mole-393459.hostingersite.com\/?p=3188"},"modified":"2024-08-24T05:53:11","modified_gmt":"2024-08-24T07:53:11","slug":"como-usar-a-formula-de-subtracao-no-excel","status":"publish","type":"post","link":"https:\/\/blog.juandesouza.com\/br\/tech\/como-usar-a-formula-de-subtracao-no-excel\/","title":{"rendered":"Como usar a f\u00f3rmula de subtra\u00e7\u00e3o no Excel"},"content":{"rendered":"<p>O Microsoft Excel \u00e9 uma poderosa ferramenta de planilha que oferece uma variedade de fun\u00e7\u00f5es matem\u00e1ticas para facilitar a an\u00e1lise de dados. Uma dessas fun\u00e7\u00f5es \u00e9 a f\u00f3rmula de subtra\u00e7\u00e3o, que permite realizar c\u00e1lculos de subtra\u00e7\u00e3o entre n\u00fameros ou intervalos de c\u00e9lulas. Neste artigo especial do Coliseu Geek, vamos explorar como usar a f\u00f3rmula de subtra\u00e7\u00e3o no Excel e fornecer exemplos pr\u00e1ticos para nos ajudar a entender como ela funciona.<span id=\"more-98220\"><\/span><\/p>\n<h3>A sintaxe b\u00e1sica da f\u00f3rmula de subtra\u00e7\u00e3o<\/h3>\n<p>A sintaxe b\u00e1sica da f\u00f3rmula de subtra\u00e7\u00e3o em <a href=\"https:\/\/www.microsoft.com\/pt-br\/microsoft-365\/excel\" target=\"_blank\" rel=\"noopener\">Excel<\/a>\u00a0\u00e9 o seguinte:<\/p><div id=\"juand-3611624837\" class=\"juand-content juand-entity-placement\"><script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-8944986240478060\"\r\n     crossorigin=\"anonymous\"><\/script>\r\n<ins class=\"adsbygoogle\"\r\n style=\"display:block; text-align:center;\"\r\n data-ad-layout=\"in-article\"\r\n data-ad-format=\"fluid\"\r\n data-ad-client=\"ca-pub-8944986240478060\"\r\n data-ad-slot=\"9601515663\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\r\n<br\/><\/div>\n<p><code>=n\u00famero1 - n\u00famero2<\/code><\/p>\n<p><strong>n\u00famero 1<\/strong>\u00a0e\u00a0<strong>n\u00famero 2<\/strong>\u00a0representam os valores que voc\u00ea deseja subtrair.<\/p>\n<p>Voc\u00ea pode inserir n\u00fameros diretamente na f\u00f3rmula ou usar refer\u00eancias de c\u00e9lulas que contenham os valores que deseja subtrair.<\/p>\n<h3>subtraindo n\u00fameros individuais<\/h3>\n<p>Para realizar uma subtra\u00e7\u00e3o simples entre n\u00fameros individuais no Excel, siga os passos abaixo:<\/p><div id=\"juand-4053894011\" class=\"juand-content_2 juand-entity-placement\"><script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-8944986240478060\"\r\n     crossorigin=\"anonymous\"><\/script>\r\n<ins class=\"adsbygoogle\"\r\n style=\"display:block; text-align:center;\"\r\n data-ad-layout=\"in-article\"\r\n data-ad-format=\"fluid\"\r\n data-ad-client=\"ca-pub-8944986240478060\"\r\n data-ad-slot=\"9601515663\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\r\n<br\/><\/div>\n<ul>\n<li>Selecione a c\u00e9lula onde voc\u00ea deseja exibir o resultado da subtra\u00e7\u00e3o.<\/li>\n<li>Insira a f\u00f3rmula de subtra\u00e7\u00e3o =n\u00famero1 \u2013 n\u00famero2, onde n\u00famero1 \u00e9 o n\u00famero do qual voc\u00ea deseja subtrair e n\u00famero2 \u00e9 o n\u00famero a ser subtra\u00eddo.<\/li>\n<li>Pressione a tecla \u201cEnter\u201d para obter o resultado da subtra\u00e7\u00e3o.<\/li>\n<li>Por exemplo, se voc\u00ea quisesse subtrair 5 de 10, sua f\u00f3rmula seria =10 \u2013 5, e o resultado seria 5.<\/li>\n<\/ul>\n<h3>Subtraindo valores de c\u00e9lulas<\/h3>\n<p>Um dos benef\u00edcios do Excel \u00e9 a capacidade de usar refer\u00eancias de c\u00e9lulas em f\u00f3rmulas. Isso permite que voc\u00ea atualize os valores das c\u00e9lulas e a subtra\u00e7\u00e3o ser\u00e1 recalculada automaticamente. Siga estes passos para subtrair os valores das c\u00e9lulas:<\/p>\n<ul>\n<li>Selecione a c\u00e9lula onde voc\u00ea deseja exibir o resultado da subtra\u00e7\u00e3o.<\/li>\n<li>Insira a f\u00f3rmula de subtra\u00e7\u00e3o =c\u00e9lula1 \u2013 c\u00e9lula2, onde c\u00e9lula1 \u00e9 a primeira c\u00e9lula que cont\u00e9m o valor a ser subtra\u00eddo e c\u00e9lula2 \u00e9 a c\u00e9lula que cont\u00e9m o valor a ser subtra\u00eddo.<\/li>\n<li>Pressione a tecla \u201cEnter\u201d para obter o resultado da subtra\u00e7\u00e3o.<\/li>\n<li>Por exemplo, se voc\u00ea quisesse subtrair o valor na c\u00e9lula A1 do valor na c\u00e9lula B1, sua f\u00f3rmula seria =A1 \u2013 B1.<\/li>\n<\/ul>\n<p>Dessa forma, se voc\u00ea alterar os valores nas c\u00e9lulas A1 ou B1, o resultado da subtra\u00e7\u00e3o ser\u00e1 atualizado automaticamente.<\/p>\n<p>Qualquer d\u00favida ou sugest\u00e3o, fique \u00e0 vontade nos coment\u00e1rios!<img decoding=\"async\" class=\"emoji\" role=\"img\" draggable=\"false\" src=\"https:\/\/s.w.org\/images\/core\/emoji\/14.0.0\/svg\/1f642.svg\" alt=\"\ud83d\ude42\" \/><\/p>\n<p>Foto por <a href=\"https:\/\/www.pexels.com\/photo\/person-holding-pen-pointing-at-graph-590020\/\" target=\"_blank\" rel=\"noopener\">Lucas<\/a><\/p>","protected":false},"excerpt":{"rendered":"<p>Microsoft Excel is a powerful spreadsheet tool that offers a variety of mathematical functions to facilitate data analysis. One such function is the subtraction formula, which allows you to perform subtraction calculations between numbers or ranges of cells. In this special Coliseu Geek article, we are going to explore how to use the subtraction formula [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":3189,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1289,1290],"tags":[],"class_list":["post-3188","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tech","category-tutorials"],"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/blog.juandesouza.com\/wp-content\/uploads\/2024\/08\/pexels-goumbik-590020-scaled-1.jpg?fit=2560%2C1695&ssl=1","jetpack_shortlink":"https:\/\/wp.me\/p8STS8-Pq","jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/blog.juandesouza.com\/br\/wp-json\/wp\/v2\/posts\/3188","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.juandesouza.com\/br\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.juandesouza.com\/br\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.juandesouza.com\/br\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.juandesouza.com\/br\/wp-json\/wp\/v2\/comments?post=3188"}],"version-history":[{"count":0,"href":"https:\/\/blog.juandesouza.com\/br\/wp-json\/wp\/v2\/posts\/3188\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.juandesouza.com\/br\/wp-json\/wp\/v2\/media\/3189"}],"wp:attachment":[{"href":"https:\/\/blog.juandesouza.com\/br\/wp-json\/wp\/v2\/media?parent=3188"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.juandesouza.com\/br\/wp-json\/wp\/v2\/categories?post=3188"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.juandesouza.com\/br\/wp-json\/wp\/v2\/tags?post=3188"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}