{"id":953,"date":"2019-04-25T14:37:40","date_gmt":"2019-04-25T11:37:40","guid":{"rendered":"https:\/\/www.test4u.eu\/excelpedia\/?p=953"},"modified":"2019-04-25T14:53:19","modified_gmt":"2019-04-25T11:53:19","slug":"the-if-function","status":"publish","type":"post","link":"https:\/\/www.test4u.eu\/excelpedia\/the-if-function\/","title":{"rendered":"The IF Function"},"content":{"rendered":"\n<p>It is used to make logical comparisons between two values and return two results. One if the comparison is TRUE and one if the comparison is FALSE. It is part of the logical functions of Excel.  <\/p>\n\n\n\n<p>The syntax of the function is the following: <\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-style-large is-layout-flow wp-block-quote-is-layout-flow\"><p> <strong>IF<\/strong><em>(<span><b>logical_test, [value_if_true], [value_if_false], &#8230;<\/b><\/span><\/em>) <\/p><cite><strong>logical_test<\/strong> : The condition you want to test. <br><strong>[value_if_true]<\/strong> : Optional. The value to return if the <strong>logical_test<\/strong> is TRUE. If omitted it returns TRUE.  <br><strong>[value_if_false]<\/strong> : Optional. The value to return if the <strong>logical_test<\/strong> is FALSE. If omitted it returns FALSE.<br><\/cite><\/blockquote>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Click on the button to practice using this function, with the help of our <strong>Online Assessment Tool<\/strong>:<\/p>\n\n\n<p class=\"button-practice-container\" ><a class=\"button button-primary button-practice\" style=\"height:auto\"  href=\"https:\/\/www.test4u.eu\/excelpedia\/wp-content\/plugins\/unlimited-integration\/run.php?id=YXVEb01zSTNCdXBxaTZETU04VTJDSGpCK2JBYXdCUExUMFc2ODU0TXlORT0=&b=anhoamdNRGtXNWl1bkY5K01CRnM3bWpoM1JHNGJ3am43ckpjeXZTL050MXd3RkdTY0Y1bjJyU1NQckxJSHU2VlNQTXhCU0tzMFA1YnlOb3dyakRPUUM3bkN5cFY2UmVSQTlmNnNVa01GVDA9\">Practice<\/a><\/p>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n\n<p class=\"has-medium-font-size\"><strong>Here is an example of how to use the IF function:<\/strong><\/p>\n\n\n\n<p>In the cell C15 enter a function which returns the word DELLA, if the content of the cell C5 is equal to the content of the cell C14; otherwise the formula returns the word other.<\/p>\n\n\n\n<figure class=\"wp-block-embed-youtube wp-block-embed is-type-video is-provider-youtube wp-embed-aspect-4-3 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<span class=\"embed-youtube\" style=\"text-align:center; display: block;\"><iframe class=\"youtube-player\" width=\"640\" height=\"360\" src=\"https:\/\/www.youtube.com\/embed\/8icfRB2J3WE?version=3&#038;rel=0&#038;showsearch=0&#038;showinfo=1&#038;iv_load_policy=1&#038;fs=1&#038;hl=en-US&#038;autohide=2&#038;wmode=transparent\" allowfullscreen=\"true\" style=\"border:0;\" sandbox=\"allow-scripts allow-same-origin allow-popups allow-presentation allow-popups-to-escape-sandbox\"><\/iframe><\/span>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>It is used to make logical comparisons between two values and return two results. One if the comparison is TRUE and one if the comparison is FALSE. It is part of the logical functions of Excel.  <\/p>\n","protected":false},"author":2,"featured_media":954,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[4],"tags":[127,75],"class_list":["post-953","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-functions","tag-if","tag-logical"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/www.test4u.eu\/excelpedia\/wp-content\/uploads\/2019\/04\/if.jpg","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/paRnIz-fn","_links":{"self":[{"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/posts\/953","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/comments?post=953"}],"version-history":[{"count":0,"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/posts\/953\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/media\/954"}],"wp:attachment":[{"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/media?parent=953"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/categories?post=953"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/tags?post=953"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}