{"id":175986,"date":"2024-01-06T21:28:50","date_gmt":"2024-01-06T20:28:50","guid":{"rendered":"https:\/\/datascientest.com\/en\/?p=175986"},"modified":"2024-01-06T21:35:56","modified_gmt":"2024-01-06T20:35:56","slug":"excel-if-function-what-is-it-for-and-how-do-i-use-it","status":"publish","type":"post","link":"https:\/\/datascientest.com\/en\/excel-if-function-what-is-it-for-and-how-do-i-use-it","title":{"rendered":"Excel If Function: what is it for and how do I use it?"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"175986\" class=\"elementor elementor-175986\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-45b1e3b e-flex e-con-boxed e-con\" data-id=\"45b1e3b\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-7cb1e3b elementor-widget elementor-widget-heading\" data-id=\"7cb1e3b\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h2 class=\"elementor-heading-title elementor-size-default\">The Excel If function returns different results, depending on whether a test criterion is true or false. Find out all you need to know about this Excel function, widely used for data analysis.<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8f2ebbe elementor-widget elementor-widget-text-editor\" data-id=\"8f2ebbe\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p>One of Excel&#8217;s great strengths is its vast catalog of functions, making it easy to apply specific operations to data cells. This is one of the main factors behind the phenomenal success of this software in the corporate world.<\/p><p>There are a wide variety of<strong> Excel functions.<\/strong> Among these, the Excel If function is one of the most widely used for comparing data, <a href=\"https:\/\/datascientest.com\/en\/creating-stunning-excel-charts-a-step-by-step-guide\">analyzing groups of data or creating interactive reports.<\/a><\/p><p>\u00a0<\/p><p>\ud83d\udca1Related articles:<\/p><table dir=\"ltr\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\" data-sheets-root=\"1\"><colgroup><col width=\"656\" \/><\/colgroup><tbody><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Power Query Date Format: How to change it on Excel and Power BI&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/power-query-date-format-how-to-change-it-on-excel-and-power-bi\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/power-query-date-format-how-to-change-it-on-excel-and-power-bi\" target=\"_blank\" rel=\"noopener\">Power Query Date Format: How to change it on Excel and Power BI<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Standard deviations in Excel: What's it for? How do I calculate it?&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/standard-deviations-in-excel-whats-it-for-how-do-i-calculate-it\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/standard-deviations-in-excel-whats-it-for-how-do-i-calculate-it\" target=\"_blank\" rel=\"noopener\">Standard deviations in Excel: What&#8217;s it for? How do I calculate it?<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Excel VBA: How to automate tasks with this language&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/excel-vba-how-to-automate-tasks-with-this-language\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/excel-vba-how-to-automate-tasks-with-this-language\" target=\"_blank\" rel=\"noopener\">Excel VBA: How to automate tasks with this language<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Pie Chart Excel: Mastering Data Visualization &quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/mastering-data-visualization-a-deep-dive-into-pie-charts-in-excel\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/mastering-data-visualization-a-deep-dive-into-pie-charts-in-excel\" target=\"_blank\" rel=\"noopener\">Pie Chart Excel: Mastering Data Visualization <\/a><\/td><\/tr><\/tbody><\/table>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-17b8c3c elementor-widget elementor-widget-image\" data-id=\"17b8c3c\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-image{text-align:center}.elementor-widget-image a{display:inline-block}.elementor-widget-image a img[src$=\".svg\"]{width:48px}.elementor-widget-image img{vertical-align:middle;display:inline-block}<\/style>\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/10\/fonction-SI-excel1.png\" title=\"\" alt=\"\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-cae6c59 e-flex e-con-boxed e-con\" data-id=\"cae6c59\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-cf3d01e elementor-widget elementor-widget-heading\" data-id=\"cf3d01e\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\"> Excel If function: What is Excel?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-cca9aed elementor-widget elementor-widget-text-editor\" data-id=\"cca9aed\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><strong>Excel<\/strong> is a spreadsheet software created by Microsoft, available on Windows, macOS, Android and iOS. It is part of the Microsoft 365 suite of tools, formerly Office.<\/p><p>This software allows you to format, <a href=\"https:\/\/datascientest.com\/en\/records-manager-a-key-data-governance-job\">organize data<\/a> and apply mathematical formulas to it. Each spreadsheet is made up of cells ordered in rows and columns, into which data is placed.<\/p><p>Users can also <strong>create graphs and pivot tables.<\/strong> The Visual Basic for Applications programming language can even be used to create macros.<\/p><p>Data analysts and other <strong>professionals use Excel<\/strong> to simplify data visualization. Many companies use Excel for business analysis, human resources management, operations management or performance reporting.<\/p><p>Since its launch in 1985, Excel has stood the test of time as the benchmark for spreadsheet software. Today, it is an essential business tool.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-e1869c7 e-flex e-con-boxed e-con\" data-id=\"e1869c7\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-2e67215 elementor-widget elementor-widget-heading\" data-id=\"2e67215\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\"> Excel If function - What are the Excel functions?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3324c74 elementor-widget elementor-widget-text-editor\" data-id=\"3324c74\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>An<strong> Excel function<\/strong> is a predefined formula, performing a specific calculation using values entered by the user as arguments.<\/p><p>Each <strong>Excel function<\/strong> has a different role and calculates a specific value. Simply enter the arguments to obtain the result value in the cell.<\/p><p>Each function has two major components: a function name, and arguments. A distinction is made between required arguments, without which the function cannot calculate the result, and optional arguments. Some functions, <strong>such as &#8220;NOW&#8221;, require no arguments at all.<\/strong><\/p><p>There are hundreds of Excel functions, but the main categories are text, date, time, logic, math, statistics, finance and search functions.<\/p><p>The easiest way to insert a function into a cell in Excel is to type the name of the function to be inserted, starting with an equal sign. For example: =SUM. You then specify the arguments in brackets, and press Enter to obtain the result.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-eeaa4fe elementor-widget elementor-widget-image\" data-id=\"eeaa4fe\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/10\/fonctions-excel1.png\" title=\"\" alt=\"\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-180bdb5 e-flex e-con-boxed e-con\" data-id=\"180bdb5\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-60647c2 elementor-widget elementor-widget-heading\" data-id=\"60647c2\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">What is the Excel If function<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d6a1dbd elementor-widget elementor-widget-text-editor\" data-id=\"d6a1dbd\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>The <strong>Excel IF function<\/strong> is one of Excel&#8217;s most frequently used functions. It allows you to test a condition, and return a different value if the result is<strong> TRUE or FALSE.<\/strong><\/p><p>An IF statement tests the condition and returns one value for a TRUE result, or another value for a FALSE result. For example, you could use this function to check whether an employee deserves a bonus. The result will be &#8220;YES&#8221; if total sales of a product exceed \u20ac5,000, or &#8220;NO&#8221; if they fall below this amount.<\/p><p>It is also possible to use the<strong> Excel IF function<\/strong> to evaluate a single function, or to include several IF functions in a formula. When multiple IF statements are used in Excel, they are referred to as <strong>embedded IF statements.<\/strong><\/p><p>The IF function is commonly used by many professionals. For example, financial analysts commonly use the SI function to evaluate and <a href=\"https:\/\/datascientest.com\/en\/4-types-of-statistical-bias-to-avoid-in-your-analyses\">analyze data by evaluating specific conditions.<\/a><\/p><p>This function can be used to evaluate texts, values or even errors. It&#8217;s not limited to checking whether one thing is equal to another and returning a single result.<\/p><p>It is also possible to use mathematical operators and perform additional calculations related to the criterion. In addition, multiple IF functions can be nested to perform multiple comparisons.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-6c1f405 e-flex e-con-boxed e-con\" data-id=\"6c1f405\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-5bf2f00 elementor-widget elementor-widget-heading\" data-id=\"5bf2f00\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">How is the Excel If function formula written?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-19a5cae elementor-widget elementor-widget-text-editor\" data-id=\"19a5cae\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>The <strong>Excel IF function<\/strong> is written as follows:<\/p><p>=IF(logical_test, true_value, false_value<\/p><p>Let&#8217;s now look at the various arguments that make up the formula. The &#8220;logical_test&#8221; argument is essential, as it is the condition to be tested and evaluated as TRUE or FALSE.<\/p><p>The logical test portion of the formula uses a comparison operator to compare values and determine whether a statement is true or false. Logical operators include: = (equal to)<\/p><p>&gt; (greater than)<\/p><p>&gt;= (greater than or equal to) &lt; (less than) &lt;= (less than or equal to) &lt;&gt; (unequal to)<\/p><p>The logical test returns a TRUE or FALSE value. The logical test argument within an IF formula needs to be returned as a Boolean TRUE or FALSE value.<\/p><p>The &#8220;true_value&#8221; and &#8220;false_value&#8221; arguments, on the other hand, are optional and indicate the value to be returned if the logical test is <strong>TRUE or FALSE.<\/strong> This value can be a number, text in quotation marks, a reference to another cell, a formula with another IF function or even a formula from other function combinations.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-50c6cfc e-flex e-con-boxed e-con\" data-id=\"50c6cfc\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-e858e5b elementor-widget elementor-widget-heading\" data-id=\"e858e5b\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">How to use the Excel If function<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6770f95 elementor-widget elementor-widget-text-editor\" data-id=\"6770f95\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>The <strong>Excel If function<\/strong> can be used in many different ways. To understand this, it&#8217;s best to look at a few examples.<\/p><p>Let&#8217;s start with a simple statement, with a basic test to check whether the value in cell B2 is greater than the value in cell A2. If the argument is true, we want a text return indicating: &#8220;YES&#8221;. On the contrary, if the argument is false, we want to see the message &#8220;NO&#8221;.<\/p><p>The formula is: =IF(B2&gt;=A2, &#8220;Yes&#8221;, &#8220;No&#8221;)<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8af8e00 elementor-widget elementor-widget-image\" data-id=\"8af8e00\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/10\/fonction-SI-excel2.png\" title=\"\" alt=\"\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6a29470 elementor-widget elementor-widget-text-editor\" data-id=\"6a29470\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>For the second example, let&#8217;s suppose we want to test cell A2 and perform an action if this cell is not empty. If the cell is empty, the formula will assign it the status &#8220;Open&#8221;. If it contains a date, the formula will assign it the status &#8220;Closed&#8221;.<\/p><p>The formula is written :<\/p><p>=IF(A2&lt;&gt;&#8221;&#8221;, &#8220;Ouvert&#8221;, &#8220;Ferm\u00e9&#8221;)<\/p><p>The third example is a store offering discounts based on quantity purchased. Each quantity range 1, 2, 3 or 4 corresponds to a unit price of 10, 8, 6 or 4.<\/p><p>Using multiple <strong>Excel If Functions,<\/strong> it is possible to create a formula to check multiple conditions and perform different calculations based on quantity. The aim is to obtain the total price by adding up the unit prices after reduction. For this example, the quantity of products purchased is indicated in box A2.<\/p><p>The formula is written :<\/p><p>=A2*IF(A2&gt;=4,4,IF(A2&gt;=3,6,IF(A2&gt;=2,8,IF(A2&gt;=1,10))))<\/p><p>This is an embedded <strong>Excel If function.<\/strong><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-148c31e elementor-widget elementor-widget-heading\" data-id=\"148c31e\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Embedded Excel If function<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a583adb elementor-widget elementor-widget-text-editor\" data-id=\"a583adb\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Data can be grouped on the basis of more than two logical tests in an <strong>Excel If function.<\/strong> For each additional category, another <strong>Excel If function<\/strong> must be nested within it.<\/p><p>The two SI instructions are nested within each other. If the result of the first test is false, the next <strong>Excel If function<\/strong> is evaluated. The process repeats until the last function is reached.<\/p><p>A maximum of 64 <strong>Excel If functions<\/strong> can be nested. However, embedded Excel If functions can become too long. Alternatively, you can use the new IFS function introduced in 2019 or the VLOOKUP, XLOOKUP or Index Match formulas.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-fb1396b e-flex e-con-boxed e-con\" data-id=\"fb1396b\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-a39d80a elementor-widget elementor-widget-heading\" data-id=\"a39d80a\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">What is the purpose of the Excel If function?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-00e8fa9 elementor-widget elementor-widget-text-editor\" data-id=\"00e8fa9\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>One use case for the <strong>Excel If function<\/strong> is data categorization. This involves dividing data into several categories according to a given criterion.<\/p><p>This process is very useful for data analysis. It is possible to filter elements by size, or use categories for a summary report, pivot table or diagram.<\/p><p>SI formulas are used for many purposes by analysts, and by many other professions. Common examples include checking whether an argument is true or false.<\/p><p>It may also be to produce a NUMBER or a TEXT, or to generate conditional formulas. For example, the result may be A2+B4 if true and C3+D7 if false.<\/p><p>This function is also used to create scenarios for financial modeling. It can also be used to create a debt schedule or a fixed asset depreciation schedule for accounting purposes.<\/p><p>The subtleties of the <strong>Excel If function<\/strong> has several subtleties. Firstly, it will work if the logical_test returns a numerical value. Any non-zero value will be treated as TRUE, and zero will be treated as FALSE.<\/p><p>A #VALUE! error may occur when the argument to &#8220;test_logic&#8221; cannot be evaluated as TRUE or FALSE. In addition, when arguments are supplied to the function as arrays, the IF function will evaluate all elements of the array.<\/p><p>Errors when using the <strong>Excel If function<\/strong> can be linked to data types. Excel cannot compare a text with a number or a date. Data must be formatted to enable comparison.<br \/>Finally, conditions can be counted using the COUNTIF and COUNTIFS functions, and summed using the<strong> SUMIF and SUMIFS functions.<\/strong><\/p><p>\u00a0<\/p><p>\ud83d\udca1Related articles:<\/p><table dir=\"ltr\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\" data-sheets-root=\"1\"><colgroup><col width=\"656\" \/><\/colgroup><tbody><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Efficient Excel Data Formatting Based on Cell Values&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/efficient-excel-data-formatting-based-on-cell-values\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/efficient-excel-data-formatting-based-on-cell-values\" target=\"_blank\" rel=\"noopener\">Efficient Excel Data Formatting Based on Cell Values<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;How do I insert columns and rows in Excel? &quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/how-do-i-insert-columns-and-rows-in-excel\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/how-do-i-insert-columns-and-rows-in-excel\" target=\"_blank\" rel=\"noopener\">How do I insert columns and rows in Excel? <\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Excel to Power BI: how to transform a pivot table in Excel into a dataset that can be used by Power BI? &quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/excel-to-power-bi-how-to-transform-a-pivot-table-in-excel-into-a-dataset-that-can-be-used-by-power-bi\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/excel-to-power-bi-how-to-transform-a-pivot-table-in-excel-into-a-dataset-that-can-be-used-by-power-bi\" target=\"_blank\" rel=\"noopener\">Excel to Power BI: how to transform a pivot table in Excel into a dataset that can be used by Power BI? <\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Excel vs. Power BI: What are the differences? &quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/excel-vs-power-bi-what-are-the-differences\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/excel-vs-power-bi-what-are-the-differences\" target=\"_blank\" rel=\"noopener\">Excel vs. Power BI: What are the differences? <\/a><\/td><\/tr><\/tbody><\/table>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-d9f273a e-flex e-con-boxed e-con\" data-id=\"d9f273a\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-c8928da elementor-widget elementor-widget-heading\" data-id=\"c8928da\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">How do I take an Excel training course?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f1190c3 elementor-widget elementor-widget-text-editor\" data-id=\"f1190c3\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>The <strong>Excel If Function<\/strong>\u00a0is just one of the many features of Microsoft Excel. To master this widely used business tool, you can choose the DataScientest training course.<\/p><p>In just 6 days, this certification course will enable you to master Excel and its most advanced functions. In addition to the <strong>Excel If function,<\/strong> you&#8217;ll learn about text, date, finance, logic and search functions. You&#8217;ll also learn how to create charts, pivot tables, matrix formulas and the <strong>Visual Basic language.<\/strong><\/p><p>At the end of this course, you&#8217;ll be able to use Excel to analyze data, manage spreadsheets and data tables, create charts and use all functions and formulas.<\/p><p>This course prepares you for the TOSA RS5252 certification and includes the official exam. This highly recognized certification enables you to demonstrate your Excel skills to employers.<\/p><p>Our program is completed entirely by distance learning via the Internet, in an intensive BootCamp format. For financing, our organization is eligible for financing options. Don&#8217;t wait any longer and discover DataScientest!<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a08afd3 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"a08afd3\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/formation-excel\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Find out more about our training courses<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-4e2ce21 e-flex e-con-boxed e-con\" data-id=\"4e2ce21\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-5ce192a elementor-widget elementor-widget-html\" data-id=\"5ce192a\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<script type=\"application\/ld+json\">\n{\n  \"@context\": \"https:\/\/schema.org\",\n  \"@type\": \"FAQPage\",\n  \"mainEntity\": [{\n    \"@type\": \"Question\",\n    \"name\": \"What is Excel's SI function?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"The SI function is one of Excel's most frequently used functions. It allows you to test a condition, and return a different value if the result is TRUE or FALSE.\"\n    }\n  },{\n    \"@type\": \"Question\",\n    \"name\": \"What is the purpose of the Excel SI function?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"One of the SI function's use cases is data categorization. This involves dividing data into several categories according to some criterion.\nThis process is very useful for data analysis. It's possible to filter elements by size, or use categories for a summary report, pivot table or diagram.\"\n    }\n  }]\n}\n<\/script>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>The Excel If function returns different results, depending on whether a test criterion is true or false. Find out all you need to know about this Excel function, widely used for data analysis. One of Excel&#8217;s great strengths is its vast catalog of functions, making it easy to apply specific operations to data cells. This [&hellip;]<\/p>\n","protected":false},"author":67,"featured_media":176006,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2425],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v21.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel If Function: what is it for and how do I use it?<\/title>\n<meta name=\"description\" content=\"The IF function is fundamental in Excel and is widely used for creating dynamic and decision-based formulas in spreadsheets, when you ...\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/datascientest.com\/en\/excel-if-function-what-is-it-for-and-how-do-i-use-it\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel If Function: what is it for and how do I use it?\" \/>\n<meta property=\"og:description\" content=\"The Excel If function returns different results, depending on whether a test criterion is true or false. Find out all you need to know about this Excel\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/en\/excel-if-function-what-is-it-for-and-how-do-i-use-it\" \/>\n<meta property=\"og:site_name\" content=\"Data Science Courses | DataScientest\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataScientestEN\" \/>\n<meta property=\"article:published_time\" content=\"2024-01-06T20:28:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-06T20:35:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/en\/files\/2024\/01\/if-excel.png\" \/>\n\t<meta property=\"og:image:width\" content=\"900\" \/>\n\t<meta property=\"og:image:height\" content=\"500\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Melanie\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:site\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Melanie\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated 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:\/\/datascientest.com\/en\/excel-if-function-what-is-it-for-and-how-do-i-use-it#article\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/excel-if-function-what-is-it-for-and-how-do-i-use-it\"},\"author\":{\"name\":\"Melanie\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\"},\"headline\":\"Excel If Function: what is it for and how do I use it?\",\"datePublished\":\"2024-01-06T20:28:50+00:00\",\"dateModified\":\"2024-01-06T20:35:56+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/datascientest.com\/en\/excel-if-function-what-is-it-for-and-how-do-i-use-it\"},\"wordCount\":1711,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"articleSection\":[\"Data Science\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/datascientest.com\/en\/excel-if-function-what-is-it-for-and-how-do-i-use-it#respond\"]}],\"copyrightYear\":\"2024\",\"copyrightHolder\":{\"@id\":\"https:\/\/datascientest.com\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/en\/excel-if-function-what-is-it-for-and-how-do-i-use-it\",\"url\":\"https:\/\/datascientest.com\/en\/excel-if-function-what-is-it-for-and-how-do-i-use-it\",\"name\":\"Excel If Function: what is it for and how do I use it?\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/#website\"},\"datePublished\":\"2024-01-06T20:28:50+00:00\",\"dateModified\":\"2024-01-06T20:35:56+00:00\",\"description\":\"The IF function is fundamental in Excel and is widely used for creating dynamic and decision-based formulas in spreadsheets, when you ...\",\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/en\/excel-if-function-what-is-it-for-and-how-do-i-use-it\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/en\/#website\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"name\":\"Data Science Courses | DataScientest\",\"description\":\"Leader in Data Science Courses\",\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/en\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/datascientest.com\/en\/#organization\",\"name\":\"DataScientest\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"contentUrl\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"width\":301,\"height\":301,\"caption\":\"DataScientest\"},\"image\":{\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/DataScientestEN\",\"https:\/\/twitter.com\/DataScientest__\",\"https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/\",\"https:\/\/www.tiktok.com\/@datascientest\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\",\"name\":\"Melanie\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"caption\":\"Melanie\"},\"url\":\"https:\/\/datascientest.com\/en\/author\/melaniekrause\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Excel If Function: what is it for and how do I use it?","description":"The IF function is fundamental in Excel and is widely used for creating dynamic and decision-based formulas in spreadsheets, when you ...","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:\/\/datascientest.com\/en\/excel-if-function-what-is-it-for-and-how-do-i-use-it","og_locale":"en_GB","og_type":"article","og_title":"Excel If Function: what is it for and how do I use it?","og_description":"The Excel If function returns different results, depending on whether a test criterion is true or false. Find out all you need to know about this Excel","og_url":"https:\/\/datascientest.com\/en\/excel-if-function-what-is-it-for-and-how-do-i-use-it","og_site_name":"Data Science Courses | DataScientest","article_publisher":"https:\/\/www.facebook.com\/DataScientestEN","article_published_time":"2024-01-06T20:28:50+00:00","article_modified_time":"2024-01-06T20:35:56+00:00","og_image":[{"width":900,"height":500,"url":"https:\/\/datascientest.com\/en\/files\/2024\/01\/if-excel.png","type":"image\/png"}],"author":"Melanie","twitter_card":"summary_large_image","twitter_creator":"@DataScientest__","twitter_site":"@DataScientest__","twitter_misc":{"Written by":"Melanie","Estimated reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/datascientest.com\/en\/excel-if-function-what-is-it-for-and-how-do-i-use-it#article","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/excel-if-function-what-is-it-for-and-how-do-i-use-it"},"author":{"name":"Melanie","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d"},"headline":"Excel If Function: what is it for and how do I use it?","datePublished":"2024-01-06T20:28:50+00:00","dateModified":"2024-01-06T20:35:56+00:00","mainEntityOfPage":{"@id":"https:\/\/datascientest.com\/en\/excel-if-function-what-is-it-for-and-how-do-i-use-it"},"wordCount":1711,"commentCount":0,"publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"articleSection":["Data Science"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/datascientest.com\/en\/excel-if-function-what-is-it-for-and-how-do-i-use-it#respond"]}],"copyrightYear":"2024","copyrightHolder":{"@id":"https:\/\/datascientest.com\/#organization"}},{"@type":"WebPage","@id":"https:\/\/datascientest.com\/en\/excel-if-function-what-is-it-for-and-how-do-i-use-it","url":"https:\/\/datascientest.com\/en\/excel-if-function-what-is-it-for-and-how-do-i-use-it","name":"Excel If Function: what is it for and how do I use it?","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/#website"},"datePublished":"2024-01-06T20:28:50+00:00","dateModified":"2024-01-06T20:35:56+00:00","description":"The IF function is fundamental in Excel and is widely used for creating dynamic and decision-based formulas in spreadsheets, when you ...","inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/en\/excel-if-function-what-is-it-for-and-how-do-i-use-it"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/en\/#website","url":"https:\/\/datascientest.com\/en\/","name":"Data Science Courses | DataScientest","description":"Leader in Data Science Courses","publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/en\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/datascientest.com\/en\/#organization","name":"DataScientest","url":"https:\/\/datascientest.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","contentUrl":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","width":301,"height":301,"caption":"DataScientest"},"image":{"@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataScientestEN","https:\/\/twitter.com\/DataScientest__","https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/","https:\/\/www.tiktok.com\/@datascientest"]},{"@type":"Person","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d","name":"Melanie","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","caption":"Melanie"},"url":"https:\/\/datascientest.com\/en\/author\/melaniekrause"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/175986"}],"collection":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/users\/67"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/comments?post=175986"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/175986\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media\/176006"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media?parent=175986"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/categories?post=175986"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/tags?post=175986"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}