{"id":439240,"date":"2022-04-28T18:00:15","date_gmt":"2022-04-28T15:00:15","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/the-basics-of-structuring-formulas-in-microsoft-excel\/"},"modified":"2022-04-28T18:00:15","modified_gmt":"2022-04-28T15:00:15","slug":"the-basics-of-structuring-formulas-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/the-basics-of-structuring-formulas-in-microsoft-excel\/","title":{"rendered":"#The Basics of Structuring Formulas in Microsoft Excel"},"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-6a2994e3030cf\" 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-6a2994e3030cf\" 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\/the-basics-of-structuring-formulas-in-microsoft-excel\/#%E2%80%9CThe_Basics_of_Structuring_Formulas_in_Microsoft_Excel%E2%80%9D\" >&#8220;The Basics of Structuring Formulas in Microsoft Excel&#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\/the-basics-of-structuring-formulas-in-microsoft-excel\/#Parts_of_a_Formula\" >Parts of a Formula<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/the-basics-of-structuring-formulas-in-microsoft-excel\/#Formula_Examples\" >Formula Examples<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/buradabiliyorum.com\/en\/the-basics-of-structuring-formulas-in-microsoft-excel\/#Get_Help_From_Excel\" >Get Help From Excel<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/buradabiliyorum.com\/en\/the-basics-of-structuring-formulas-in-microsoft-excel\/#Start_Your_Formula\" >Start Your Formula<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/buradabiliyorum.com\/en\/the-basics-of-structuring-formulas-in-microsoft-excel\/#View_the_Function_Library\" >View the Function Library<\/a><\/li><\/ul><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h1><span class=\"ez-toc-section\" id=\"%E2%80%9CThe_Basics_of_Structuring_Formulas_in_Microsoft_Excel%E2%80%9D\"><\/span>&#8220;The Basics of Structuring Formulas in Microsoft Excel&#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-757715\" data-pagespeed-lazy-srcset=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_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\/09\/microsoft_excel_hero_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\/09\/microsoft_excel_hero_1200x675.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Microsoft Excel logo on a green background\" 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>We\u2019re not all mathematicians, but some tasks in Microsoft Excel are best done using formulas. Maybe you\u2019re new to writing formulas or are trying but keep\u00a0getting confusing errors. Here, we\u2019ll cover the basics of structuring formulas in Excel.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Parts_of_a_Formula\"><\/span>Parts of a Formula<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>While the exact elements can vary, a formula can use the following pieces.<\/p>\n<p><strong>Equal Sign<\/strong>: All formulas in Excel, and Google Sheets as well, start with an equal sign (=). Once you type it into a cell, you may im<a href=\"https:\/\/buradabiliyorum.com\/en\/category\/social-mediaa\/\" data-internallinksmanager029f6b8e52c=\"1\" title=\"Social Media\" target=\"_blank\" rel=\"noopener\">media<\/a>tely see suggestions for functions or formulas.<\/p>\n<p><strong>Cell Reference<\/strong>: While you can type values directly into formulas (as a constant), it\u2019s possible and usually handier to pull values from other cells. An example cell reference is A1, which is the value in column A, row 1. References can be <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/school\/microsoft-excel-formulas-and-functions\/lesson3\/\">relative, absolute, or mixed.<\/p>\n<ul>\n<li><strong>Relative Reference<\/strong>: This refers to the relative position of the cell. If you use the reference A1 in your formula and change the position of the reference (for example, if you copy and paste the data somewhere else), the formula updates automatically.<\/li>\n<li><strong>Absolute Reference<\/strong>: This refers to a specific position of the cell. If you use the reference $A$1 in your formula and change the position of the reference, the formula does not update automatically.<\/li>\n<li><strong>Mixed Reference<\/strong>: This refers to a relative column and absolute row or vice versa. For instance, if you use A$1 or $A1 in your formula and change the position of the reference, the formula only updates for the relative column or row automatically.<\/li>\n<\/ul>\n<p><strong>Constant<\/strong>: You can think of a constant as an inserted value. This is a value that you enter directly into the formula instead of or in addition to a cell reference. For example, instead of using A1 in the formula, you might use its value\u201415.<\/p>\n<p><strong>Operator<\/strong>: This is a special character that performs a task. For instance, the ampersand is the text concatenation operator for combining text strings. Here are a few more:<\/p>\n<ul>\n<li><strong>Arithmetic Operators<\/strong>: These include an asterisk for multiplication and a plus sign for addition.<\/li>\n<li><strong>Comparison Operators<\/strong>: These include a greater than, less than, and equal sign.<\/li>\n<li><strong>Reference Operators<\/strong>: These include a colon to designate a cell range as in A1:A5 and a comma to combine multiple cell ranges as in A1:A5,B1:5.<\/li>\n<\/ul>\n<p><strong>Parentheses<\/strong>: Like in an algebra equation, you may use parentheses to specify the part of the formula to perform first. For instance, if the formula is <code>=2+2*3<\/code>, the answer is 8 because Excel performs the multiplication portion first. But if you use <code>=(2+2)*3<\/code>, the answer is 12 because the portion within parentheses is performed before the multiplication.<\/p>\n<p>Additionally, functions begin with an opening parenthesis, followed by the arguments (references, values, text, arrays, etc.), and finish with the closing parenthesis. Even if nothing <a href=\"https:\/\/buradabiliyorum.com\/en\/category\/download-scripts-themes-apps\/\" data-internallinksmanager029f6b8e52c=\"9\" title=\"Download Scripts &amp; Themes &amp; Apps\" target=\"_blank\" rel=\"noopener\">app<\/a>ears in the parentheses as in <code>=TODAY()<\/code> which gives you the current date, you must still include the parentheses.<\/p>\n<p><strong>Function<\/strong>: A common but not required part of a formula is a function. As with our above example the TODAY function provides today\u2019s date. Excel supports many, many functions for working with numbers, text, lookups, information, and much more.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Formula_Examples\"><\/span>Formula Examples<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Now that you know the basic parts of a formula, let\u2019s look at the syntaxes for some examples.<\/p>\n<p>Here is a formula to <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/696837\/how-to-calculate-the-sum-of-cells-in-excel\/\">add the values in two cells. You have the equal sign, first cell reference (relative reference), plus sign (operator), and second reference (relative reference).<\/p>\n<pre>=A1+B1<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-798333\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/04\/AddCells-ExcelStructureFormulas.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Formula to add cell references\" width=\"410\" height=\"124\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>This formula adds distinct values\u00a0instead. You have the equal sign, first value (constant), plus sign (operator), and second value (constant).<\/p>\n<pre>=15+20<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-798332\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/04\/AddNumbers-ExcelStructureFormulas.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Formula to add numbers\" width=\"422\" height=\"126\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>For a function example, you can add the values in a cell range. Start with the equal sign, enter the function followed by an opening parenthesis, insert the first cell in the range, a colon (reference operator), last cell in the range, and finish with the closing parenthesis.<\/p>\n<pre>=SUM(A1:A5)<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-798334\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/04\/SumRange-ExcelStructureFormulas.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Formula to add a cell range\" width=\"435\" height=\"199\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Another symbol you may see in a formula is a quotation mark. This is commonly used when creating formulas for working with text, although quotes are not exclusive to text. Here\u2019s an example.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>9 Useful Microsoft Excel Functions for Working With Text<\/em><\/strong><\/p>\n<p>You can use the SUBSTITUTE function in Excel to replace certain text with new text. Using this formula, you can substitute Smith for Jones in cell A1:<\/p>\n<pre>=SUBSTITUTE(A1,\"Jones\",\"Smith\")<\/pre>\n<p>As you can see, both the current (Jones) and new (Smith) text are contained within quotation marks.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-798335\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/04\/SubstituteFormula-ExcelStructureFormulas.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Formula to substitute text\" width=\"583\" height=\"200\" 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=\"Get_Help_From_Excel\"><\/span>Get Help From Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>It can take time and practice to get the hang of writing formulas. Luckily, Excel does offer some <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/761846\/how-to-find-the-function-you-need-in-microsoft-excel\/\">help when you\u2019re using functions in your formulas.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Find the Function You Need in Microsoft Excel<\/em><\/strong><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Start_Your_Formula\"><\/span>Start Your Formula<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>If you plan to use a function, you can get a jumpstart on the formula.<\/p>\n<p>Select the cell where you want the formula, type the equal sign, and enter the first letter or two of the function you want to use. You\u2019ll see a drop-down <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/765624\/basic-excel-functions-everybody-should-know\/\">list of functions that apply.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-798336\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/04\/StartFunction-ExcelStructureFormulas.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Letters entered for a function to display the list\" width=\"507\" height=\"285\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Double-click the function you want and you\u2019ll see the syntax for the formula you need to create.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-798337\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/04\/SumSyntax-ExcelStructureFormulas.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Formula for SUM in Excel\" width=\"650\" height=\"185\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You can then click an argument in the formula and enter or select what you want to use. Follow the formula you see by entering commas or other expected operators until you complete the formula.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-798338\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/04\/SumFormula-ExcelStructureFormulas.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Using the formula for SUM in Excel\" width=\"650\" height=\"165\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"View_the_Function_Library\"><\/span>View the Function Library<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Even if you know the function you want, you can take a look at the syntax for the formula ahead of time. This helps you prepare the data if it\u2019s not ready.<\/p>\n<p>Go to the Formulas tab and click \u201cInsert Function\u201d on the left side of the ribbon.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-798341\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/04\/InsertFunctionRibbon-ExcelStructureFormulas.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Insert Function on the Formulas tab\" width=\"600\" height=\"144\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Enter the function into the Search box at the top, hit \u201cGo,\u201d and then select it from the results.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-798340\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/04\/InsertFunctionSearch-ExcelStructureFormulas.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Find a function box\" width=\"629\" height=\"475\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You\u2019ll then see the expected syntax for the function near the bottom of the window. Plus, you get a description of the function for additional help. Below, you can see what you need for the <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/791172\/how-to-use-the-count-function-in-microsoft-excel\/\">COUNT function.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-798339\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/04\/InsertFunctionSyntax-ExcelStructureFormulas.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"COUNT function syntax and description in Excel\" width=\"629\" height=\"475\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Hopefully these explanations and tips help you create the formulas you need in Microsoft Excel!<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>12 Basic Excel Functions Everybody Should Know<\/em><\/strong><\/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\/798325\/excel-formula-structure-basics\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;The Basics of Structuring Formulas in Microsoft Excel&#8221; We\u2019re not all mathematicians, but some tasks in Microsoft Excel are best done using formulas. Maybe you\u2019re new to writing formulas or are trying but keep\u00a0getting confusing errors. Here, we\u2019ll cover the basics of structuring formulas in Excel. Parts of a Formula While the exact elements can&#8230;<\/p>\n","protected":false},"author":1,"featured_media":439241,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-439240","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\/439240","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=439240"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/439240\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/439241"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=439240"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=439240"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=439240"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}