{"id":4530,"date":"2024-03-15T03:03:00","date_gmt":"2024-03-15T07:03:00","guid":{"rendered":"https:\/\/exceltheatre.com\/blog\/?p=4530"},"modified":"2025-08-06T19:12:09","modified_gmt":"2025-08-06T23:12:09","slug":"video-make-simple-if-formula-excel","status":"publish","type":"post","link":"https:\/\/exceltheatre.com\/blog\/archives\/2024\/03\/15\/video-make-simple-if-formula-excel\/","title":{"rendered":"Video &#8211; How to Make a Simple IF Formula in Excel"},"content":{"rendered":"<p>Use the Excel IF function when you want to test something. The IF formula will show one result if the test result is True, and a different result if the test result is False.<\/p>\n<p><!--more--><\/p>\n<p>For example:<\/p>\n<ul>\n<li>Check if cell D7 is empty.<\/li>\n<li>If it is, the result is an empty string.<\/li>\n<li>If not, multiply C7 times D7.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"if function checks for empty cell\" src=\"https:\/\/www.contextures.com\/images\/functions\/iffunction01.png\" alt=\"if function checks for empty cell\" width=\"335\" height=\"226\" border=\"1\" \/><\/p>\n<h3>Video: Simple IF Formula in Excel<\/h3>\n<p>In the short video below, I show the steps for setting up a simple IF formula.<\/p>\n<p><strong>Video Timeline<\/strong><\/p>\n<ul>\n<li>0:00 Introduction<\/li>\n<li>0:13 Do a Test<\/li>\n<li>0:39 Order Form<\/li>\n<li>0:55 Simple IF Formula<\/li>\n<li>1:39 Test the Formula<\/li>\n<\/ul>\n<p><iframe loading=\"lazy\" title=\"Make a Simple IF Formula in Excel\" width=\"840\" height=\"473\" src=\"https:\/\/www.youtube.com\/embed\/l8i9EWmshSc?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<h3>Get the Sample File<\/h3>\n<p>For more IF formula examples, and to get the sample Excel workbook, <a href=\"https:\/\/www.contextures.com\/xlfunctions06_excel-if-function.html\">go to the IF Function Examples page<\/a> on my Contextures site. The zipped file is in xlsx format, and does not contain any macros.<\/p>\n<ul>\n<li><strong>Nested IFs<\/strong>: The examples on that page also show how to created <strong>nested IF formulas<\/strong>, where two or more IF functions are used, to create multiple tests.<\/li>\n<li><strong>IFS<\/strong>: And if you&#8217;re using Excel 365, there are examples for the <strong>new Excel IFS function<\/strong>.<\/li>\n<\/ul>\n<h3>Related IF Function Articles<\/h3>\n<p>\u2022 <a href=\"https:\/\/www.contextures.com\/xlfunctions06_excel-if-function.html\" target=\"_blank\" rel=\"noopener\">Excel IF Function Examples<\/a><\/p>\n<p>\u2022 <a href=\"https:\/\/contexturesblog.com\/archives\/2021\/03\/04\/excel-nested-if-formula-horror-stories\/\" target=\"_blank\" rel=\"noopener\">Excel Nested IF Formula Horror Stories<\/a><\/p>\n<p>And instead of creating long, complicated, multi-level nested IF formulas, considering using a lookup formula instead.<\/p>\n<p>\u2022 <a href=\"https:\/\/www.contextures.com\/xlfunctions03.html\" target=\"_blank\" rel=\"noopener\">INDEX \/ MATCH Function Examples<\/a><\/p>\n<p>\u2022 <a href=\"https:\/\/www.contextures.com\/excelvlookupexamples.html\" target=\"_blank\" rel=\"noopener\">VLOOKUP Function Examples<\/a><\/p>\n<p>\u2022 <a href=\"https:\/\/www.contextures.com\/excellookupfunctions.html\" target=\"_blank\" rel=\"noopener\">Lookup Functions Compared<\/a><\/p>\n<p>________________________<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Use the Excel IF function when you want to test something. The IF formula will show one result if the test result is True, and a different result if the test result is False.<\/p>\n","protected":false},"author":2,"featured_media":4533,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_kadence_starter_templates_imported_post":false,"footnotes":""},"categories":[6],"tags":[],"class_list":["post-4530","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-videos"],"_links":{"self":[{"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/posts\/4530","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/comments?post=4530"}],"version-history":[{"count":3,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/posts\/4530\/revisions"}],"predecessor-version":[{"id":4673,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/posts\/4530\/revisions\/4673"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/media\/4533"}],"wp:attachment":[{"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/media?parent=4530"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/categories?post=4530"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/tags?post=4530"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}