{"id":249,"date":"2018-09-12T19:41:11","date_gmt":"2018-09-12T22:41:11","guid":{"rendered":"http:\/\/lucianodev.com.br\/blog\/?p=249"},"modified":"2018-09-12T20:04:32","modified_gmt":"2018-09-12T23:04:32","slug":"excel-primeiro-contato-com-funcoes-formulas","status":"publish","type":"post","link":"https:\/\/lucianodev.com.br\/blog\/excel-primeiro-contato-com-funcoes-formulas\/","title":{"rendered":"Excel: Primeiro contato com Fun\u00e7\u00f5es (F\u00f3rmulas)"},"content":{"rendered":"<p><script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><span style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" data-mce-type=\"bookmark\" class=\"mce_SELRES_start\">\ufeff<\/span><\/script><br \/>\n<ins class=\"adsbygoogle\" style=\"display: block; text-align: center;\" data-ad-layout=\"in-article\" data-ad-format=\"fluid\" data-ad-client=\"ca-pub-4648498281437791\" data-ad-slot=\"5451138398\"><\/ins><br \/>\n<script>\n     (adsbygoogle = window.adsbygoogle || []).push({});\n<\/script><\/p>\n<p>Ol\u00e1 pessoal, neste POST estaremos dando continuidade no aprendizado do uso das f\u00f3rmulas do Excel, onde iremos aprender como utilizar fun\u00e7\u00f5es em uma f\u00f3rmula. Se voc\u00ea ainda n\u00e3o viu o POST anterior onde aprendemos o que vem a ser uma f\u00f3rmula no Excel, <a href=\"https:\/\/lucianodev.com.br\/blog\/excel-introducao-ao-uso-das-formulas-passo-a-passo\/\"><strong>CLIQUE AQUI<\/strong><\/a>.<\/p>\n<p>Bom, vamos dar continuidade ao aprendizado sobre o uso de f\u00f3rmulas atrav\u00e9s da aplica\u00e7\u00e3o de fun\u00e7\u00f5es.<\/p>\n<h2>Usando Fun\u00e7\u00f5es em F\u00f3rmulas<\/h2>\n<p>\u00c9 muito comum dentro de uma f\u00f3rmula do Excel executar tarefas e\/ou c\u00e1lculos espec\u00edficos que envolvem muito mais do que simples opera\u00e7\u00f5es aritm\u00e9ticas (como processamentos e algumas avalia\u00e7\u00f5es condicionais). Para isso o Excel oferece <strong>fun\u00e7\u00f5es<\/strong> que podem ser introduzidas dentro das f\u00f3rmulas para a realiza\u00e7\u00e3o de c\u00e1lculos e processamentos espec\u00edficos para que possamos obter um resultado.<\/p>\n<p>O Excel oferece um conjunto muito grande de fun\u00e7\u00f5es, onde cada uma possui uma finalidade especial dentro de sua aplica\u00e7\u00e3o. Vamos conhecer aqui duas fun\u00e7\u00f5es muito b\u00e1sicas (e constantemente usadas) para realizar opera\u00e7\u00f5es aritm\u00e9ticas de uma forma f\u00e1cil e flex\u00edvel: As fun\u00e7\u00f5es <strong>SOMA<\/strong> e <strong>M\u00c9DIA<\/strong>.<\/p>\n<p><script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><span style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" data-mce-type=\"bookmark\" class=\"mce_SELRES_start\">\ufeff<\/span><\/script><br \/>\n<ins class=\"adsbygoogle\" style=\"display: block; text-align: center;\" data-ad-layout=\"in-article\" data-ad-format=\"fluid\" data-ad-client=\"ca-pub-4648498281437791\" data-ad-slot=\"5451138398\"><\/ins><br \/>\n<script>\n     (adsbygoogle = window.adsbygoogle || []).push({});\n<\/script><\/p>\n<h3><strong>A fun\u00e7\u00e3o SOMA<\/strong><\/h3>\n<p>A fun\u00e7\u00e3o <strong>SOMA<\/strong>, como o pr\u00f3prio nome j\u00e1 fiz, efetua a &#8220;soma&#8221; de um conjunto de valores passados como par\u00e2metros para ela. Vamos conhecer a sua sintaxe b\u00e1sica (chamamos de <em>sintaxe<\/em> o conjunto de regras que descreve a forma como uma fun\u00e7\u00e3o ou express\u00e3o deve ser escrita corretamente):<\/p>\n<p style=\"padding-left: 30px;\">\u00a0= SOMA(<em><strong>&lt;valor1&gt;<\/strong><\/em> ;<strong><em> &lt;valor2&gt;<\/em><\/strong> ; <em><strong>&lt;valor3&gt;<\/strong><\/em> ;&#8230;.)<\/p>\n<p>&nbsp;<\/p>\n<p>Entendendo a sintaxe da fun\u00e7\u00e3o: Perceba que a fun\u00e7\u00e3o recebe como par\u00e2metro &#8220;valores&#8221; (que podem ser um valor num\u00e9rico simples ou uma c\u00e9lula da planilha que contenha um valor n\u00famerico), e esses valores ser\u00e3o no final somados retornando no final o resultado da soma.<\/p>\n<p>Vamos demonstrar o uso da f\u00f3rmula de uma maneira &#8220;absurdamente&#8221; simples. Considere a seguinte planilha em Excel abaixo:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-256\" src=\"https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_1.jpg\" alt=\"\" width=\"405\" height=\"171\" srcset=\"https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_1.jpg 405w, https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_1-300x127.jpg 300w, https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_1-110x46.jpg 110w\" sizes=\"auto, (max-width: 405px) 100vw, 405px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Clique na c\u00e9lula <span style=\"color: #339966;\"><strong>C3 <\/strong><\/span>onde iremos inserir uma f\u00f3rmula. Em seguida digite a seguinte express\u00e3o (sem aspas) &#8220;=SOMA(<span style=\"color: #800000;\"><strong>A3<\/strong><\/span>;<span style=\"color: #333399;\"><strong>B3<\/strong><\/span>)&#8221;:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-257\" src=\"https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_2.jpg\" alt=\"\" width=\"400\" height=\"168\" srcset=\"https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_2.jpg 400w, https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_2-300x126.jpg 300w, https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_2-110x46.jpg 110w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><\/p>\n<p>Tecle agora <strong>ENTER <\/strong>e veja que a f\u00f3rmula foi inserida e calculada com SUCESSO.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-258\" src=\"https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_3.jpg\" alt=\"\" width=\"400\" height=\"170\" srcset=\"https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_3.jpg 400w, https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_3-300x128.jpg 300w, https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_3-110x47.jpg 110w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><\/p>\n<p><script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><span style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" data-mce-type=\"bookmark\" class=\"mce_SELRES_start\">\ufeff<\/span><\/script><br \/>\n<ins class=\"adsbygoogle\" style=\"display: block; text-align: center;\" data-ad-layout=\"in-article\" data-ad-format=\"fluid\" data-ad-client=\"ca-pub-4648498281437791\" data-ad-slot=\"5451138398\"><\/ins><br \/>\n<script>\n     (adsbygoogle = window.adsbygoogle || []).push({});\n<\/script><\/p>\n<h3>\u00a0Usando o assistente &#8220;Inserir Fun\u00e7\u00e3o&#8221;<\/h3>\n<p>Em uma f\u00f3rmula que utilize fun\u00e7\u00f5es, a forma mais comum e pr\u00e1tica \u00e9 digitando a f\u00f3rmula com os seus respectivos valores (par\u00e2metros). Existe tamb\u00e9m uma outra forma de inserirmos uma fun\u00e7\u00e3o SEM A NECESSIDADE de construir a f\u00f3rmula por completo NA M\u00c3O: Usando o assistente &#8220;Inserir Fun\u00e7\u00e3o&#8221;. Vamos aprender como usamos ele.<\/p>\n<p>Considere novamente a mesma planilha apresentada,sem a f\u00f3rmula:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-256\" src=\"https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_1.jpg\" alt=\"\" width=\"405\" height=\"171\" srcset=\"https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_1.jpg 405w, https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_1-300x127.jpg 300w, https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_1-110x46.jpg 110w\" sizes=\"auto, (max-width: 405px) 100vw, 405px\" \/><\/p>\n<p>Clique na c\u00e9lula <strong>C3 <\/strong>para selecionarmos ela:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-260\" src=\"https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_4.jpg\" alt=\"\" width=\"456\" height=\"179\" srcset=\"https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_4.jpg 456w, https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_4-300x118.jpg 300w, https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_4-110x43.jpg 110w, https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_4-420x165.jpg 420w\" sizes=\"auto, (max-width: 456px) 100vw, 456px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Localize e clique no recurso &#8220;Inserir fun\u00e7\u00e3o&#8221; (identificado por um <strong><em>fx<\/em><\/strong>):<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-262\" src=\"https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_5.jpg\" alt=\"\" width=\"395\" height=\"154\" srcset=\"https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_5.jpg 395w, https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_5-300x117.jpg 300w, https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_5-110x43.jpg 110w\" sizes=\"auto, (max-width: 395px) 100vw, 395px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Ser\u00e1 aberta a seguinte caixa de di\u00e1logo:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-263\" src=\"https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_6.jpg\" alt=\"\" width=\"450\" height=\"375\" srcset=\"https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_6.jpg 450w, https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_6-300x250.jpg 300w, https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_6-110x92.jpg 110w, https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_6-420x350.jpg 420w\" sizes=\"auto, (max-width: 450px) 100vw, 450px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Na caixa de di\u00e1logo que aparece aqui no meu computador a fun\u00e7\u00e3o <strong>SOMA<\/strong> j\u00e1 pode ser vista, por\u00e9m , pode ser que no seu Excel ela <strong>n\u00e3o apare\u00e7a na primeira vez<\/strong>. Para visualizarmos a fun\u00e7\u00e3o <strong>SOMA <\/strong>localize a caixa de combina\u00e7\u00e3o &#8220;Categoria&#8221;, como \u00e9 indicada a seguir:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-265\" src=\"https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_7.jpg\" alt=\"\" width=\"450\" height=\"375\" srcset=\"https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_7.jpg 450w, https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_7-300x250.jpg 300w, https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_7-110x92.jpg 110w, https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_7-420x350.jpg 420w\" sizes=\"auto, (max-width: 450px) 100vw, 450px\" \/><\/p>\n<p>Clique no local indicado abaixo e na lista que surge selecione a op\u00e7\u00e3o &#8220;Matem\u00e1tica e Trigonometria&#8221;:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-266\" src=\"https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_8.jpg\" alt=\"\" width=\"450\" height=\"375\" srcset=\"https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_8.jpg 450w, https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_8-300x250.jpg 300w, https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_8-110x92.jpg 110w, https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_8-420x350.jpg 420w\" sizes=\"auto, (max-width: 450px) 100vw, 450px\" \/><\/p>\n<p>Perceba que uma lista de fun\u00e7\u00f5es da categoria escolhida \u00e9 mostrada. Localize e selecione a fun\u00e7\u00e3o <strong>SOMA<\/strong>:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-267\" src=\"https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_9.jpg\" alt=\"\" width=\"450\" height=\"377\" srcset=\"https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_9.jpg 450w, https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_9-300x250.jpg 300w, https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_9-110x92.jpg 110w, https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_9-420x352.jpg 420w\" sizes=\"auto, (max-width: 450px) 100vw, 450px\" \/><\/p>\n<p>Feito isso clique em &#8220;OK&#8221;, e ser\u00e1 aberta a seguinte caixa de di\u00e1logo:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-268\" src=\"https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_10.jpg\" alt=\"\" width=\"598\" height=\"344\" srcset=\"https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_10.jpg 598w, https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_10-300x173.jpg 300w, https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_10-110x63.jpg 110w, https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_10-420x242.jpg 420w\" sizes=\"auto, (max-width: 598px) 100vw, 598px\" \/><\/p>\n<p>Podemos ver na figura acima que ele j\u00e1 colocou o intervalo correto das c\u00e9lulas que desejo somar (entre <span style=\"color: #339966;\"><strong>A3<\/strong> <\/span>e <strong><span style=\"color: #008080;\">B3<\/span><\/strong>, expresso na f\u00f3rmula &#8220;<strong><span style=\"color: #800000;\">A3<\/span><\/strong>:<span style=\"color: #008000;\"><strong>B3<\/strong><\/span>&#8220;). Como &#8220;for\u00e7a do h\u00e1bito&#8221;, iremos fazer a soma das c\u00e9lulas de forma tradicional (pois, nem sempre o intervalo que ele preenche no campo acima \u00e9 v\u00e1lido).<\/p>\n<p>Vamos apagar o valor automaticamente preenchido e coloque em cada campo da caixa de di\u00e1logo as c\u00e9lulas que ser\u00e3o somadas, conforme mostra abaixo:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-269\" src=\"https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_11.jpg\" alt=\"\" width=\"598\" height=\"344\" srcset=\"https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_11.jpg 598w, https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_11-300x173.jpg 300w, https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_11-110x63.jpg 110w, https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_11-420x242.jpg 420w\" sizes=\"auto, (max-width: 598px) 100vw, 598px\" \/><\/p>\n<p>Perceba que surgiu uma terceira caixa de texto &#8220;em branco&#8221;, podemos ignorar ela (pois automaticamente quando os campos s\u00e3o preenchidos o Excel vai criando as caixas de texto). Para finalizarmos clique em &#8220;OK&#8221; e veja o resultado:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-258\" src=\"https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_3.jpg\" alt=\"\" width=\"400\" height=\"170\" srcset=\"https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_3.jpg 400w, https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_3-300x128.jpg 300w, https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_3-110x47.jpg 110w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><\/p>\n<p><script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><span style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" data-mce-type=\"bookmark\" class=\"mce_SELRES_start\">\ufeff<\/span><\/script><br \/>\n<ins class=\"adsbygoogle\" style=\"display: block; text-align: center;\" data-ad-layout=\"in-article\" data-ad-format=\"fluid\" data-ad-client=\"ca-pub-4648498281437791\" data-ad-slot=\"5451138398\"><\/ins><br \/>\n<script>\n     (adsbygoogle = window.adsbygoogle || []).push({});\n<\/script><\/p>\n<h3>\u00a0A fun\u00e7\u00e3o M\u00e9dia<\/h3>\n<p>Como o pr\u00f3prio nome diz, essa fun\u00e7\u00e3o \u00e9 respons\u00e1vel por realizar a m\u00e9dia aritm\u00e9tica de um conjunto de valores passados como par\u00e2metro. Vejamos a sua sintaxe:<\/p>\n<p>= M\u00c9DIA(<em><strong>&lt;valor1&gt;<\/strong><\/em> ;<strong><em> &lt;valor2&gt;<\/em><\/strong> ; <em><strong>&lt;valor3&gt;<\/strong><\/em> ;&#8230;.)<\/p>\n<p>&nbsp;<\/p>\n<p>Por exemplo: A fun\u00e7\u00e3o &#8220;=M\u00c9DIA(<strong>A1<\/strong>;<span style=\"color: #800000;\"><strong>B1<\/strong><\/span>;<span style=\"color: #008000;\"><strong>C1<\/strong><\/span>)&#8221; equivale a: &#8220;=(<strong><span style=\"color: #0000ff;\">A1<\/span><\/strong>+<strong><span style=\"color: #993300;\">B1<\/span><\/strong>+<strong><span style=\"color: #333333;\">C1<\/span><\/strong>) \/ 3&#8243;. Vejamos outras compara\u00e7\u00f5es abaixo:<\/p>\n<p>&#8220;=M\u00c9DIA(<strong>A1<\/strong>;<strong>C2<\/strong>)&#8221; <em>EQUIVALE A\u00a0 &#8220;=(<strong>A1<\/strong>+<strong>C2<\/strong>) \/ 2&#8243;<\/em><\/p>\n<p>&#8220;=M\u00c9DIA(<strong>A1:<\/strong><strong>A4<\/strong>)&#8221; <em>EQUIVALE A\u00a0 &#8220;=(<strong>A1<\/strong>+<strong>A2 + A3 + A4<\/strong>) \/ 4&#8243;<\/em><\/p>\n<p>Vamos ver uma demonstra\u00e7\u00e3o de sua aplica\u00e7\u00e3o. Considere a seguinte planilha abaixo:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-272\" src=\"https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_12.jpg\" alt=\"\" width=\"675\" height=\"155\" srcset=\"https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_12.jpg 675w, https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_12-300x69.jpg 300w, https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_12-110x25.jpg 110w, https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_12-420x96.jpg 420w\" sizes=\"auto, (max-width: 675px) 100vw, 675px\" \/><\/p>\n<p>Selecione a c\u00e9lula <strong><span style=\"color: #800000;\">F3<\/span> <\/strong>onde ser\u00e1 aplicada a f\u00f3rmula <strong>M\u00c9DIA<\/strong>. Agora vamos digitar &#8220;=M\u00c9DIA(<strong><span style=\"color: #008000;\">B3<\/span><\/strong>:<strong><span style=\"color: #000080;\">E3<\/span><\/strong>)&#8221;:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-273\" src=\"https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_13.jpg\" alt=\"\" width=\"481\" height=\"160\" srcset=\"https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_13.jpg 481w, https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_13-300x100.jpg 300w, https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_13-110x37.jpg 110w, https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_13-420x140.jpg 420w\" sizes=\"auto, (max-width: 481px) 100vw, 481px\" \/><\/p>\n<p>Pressione <strong>ENTER <\/strong>para que a f\u00f3rmula seja inserida.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-274\" src=\"https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_14.jpg\" alt=\"\" width=\"675\" height=\"138\" srcset=\"https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_14.jpg 675w, https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_14-300x61.jpg 300w, https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_14-110x22.jpg 110w, https:\/\/lucianodev.com.br\/blog\/wp-content\/uploads\/2018\/09\/img_post_formula_func_14-420x86.jpg 420w\" sizes=\"auto, (max-width: 675px) 100vw, 675px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Conforme j\u00e1 foi mostrado, poder\u00edamos fazer a inser\u00e7\u00e3o desta fun\u00e7\u00e3o usando o assistente &#8220;Inserir Fun\u00e7\u00e3o&#8221; (assim como fizemos para <strong>SOMA<\/strong>).<\/p>\n<p>Bom pessoal, por hoje \u00e9 s\u00f3. Em breve estarei escrevendo mais conte\u00fados sobre o uso de f\u00f3rmulas usadas no Excel.<\/p>\n<p>Se voc\u00ea achou esse POST de grande ajuda para voc\u00ea, compartilhe para que outros tamb\u00e9m possam aprender o uso de fun\u00e7\u00f5es em f\u00f3rmulas do Excel.<\/p>\n<p>Um forte abra\u00e7o para todos&#8230;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ol\u00e1 pessoal, neste POST estaremos dando continuidade no aprendizado do uso das f\u00f3rmulas do Excel, onde iremos aprender como utilizar fun\u00e7\u00f5es em uma f\u00f3rmula. Se voc\u00ea ainda n\u00e3o viu o&hellip;<\/p>\n","protected":false},"author":1,"featured_media":250,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7,6],"tags":[],"class_list":["post-249","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-office"],"_links":{"self":[{"href":"https:\/\/lucianodev.com.br\/blog\/wp-json\/wp\/v2\/posts\/249","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/lucianodev.com.br\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/lucianodev.com.br\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/lucianodev.com.br\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/lucianodev.com.br\/blog\/wp-json\/wp\/v2\/comments?post=249"}],"version-history":[{"count":15,"href":"https:\/\/lucianodev.com.br\/blog\/wp-json\/wp\/v2\/posts\/249\/revisions"}],"predecessor-version":[{"id":279,"href":"https:\/\/lucianodev.com.br\/blog\/wp-json\/wp\/v2\/posts\/249\/revisions\/279"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/lucianodev.com.br\/blog\/wp-json\/wp\/v2\/media\/250"}],"wp:attachment":[{"href":"https:\/\/lucianodev.com.br\/blog\/wp-json\/wp\/v2\/media?parent=249"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/lucianodev.com.br\/blog\/wp-json\/wp\/v2\/categories?post=249"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/lucianodev.com.br\/blog\/wp-json\/wp\/v2\/tags?post=249"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}