{"id":184,"date":"2021-07-02T15:13:40","date_gmt":"2021-07-02T15:13:40","guid":{"rendered":"https:\/\/excelforgbs.com\/?page_id=184"},"modified":"2022-06-10T17:26:52","modified_gmt":"2022-06-10T17:26:52","slug":"logical-functions","status":"publish","type":"page","link":"https:\/\/excelforgbs.com\/?page_id=184","title":{"rendered":"Logical Functions"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Logical functions return TRUE or FALSE and are sometimes called Boolean functions.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Here is an introduction to how to use Boolean functions in Excel.  <a href=\"https:\/\/excelforgbs.com\/?p=283\">TRUE\/FALSE functions<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The IF() function is used to create formulas that depend on a boolean outcome.    <a href=\"http:\/\/excelforgbs.com\/?p=286\">Using IF() to control calculations<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Errors can occur in formulas (such as division by zero).  Excel provides a function that will give an alternative outcome (such as blank or zero) if an error occurs in a formula.  <a href=\"http:\/\/excelforgbs.com\/?p=296\">IFERROR function<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/excelforgbs.com\/?page_id=186\">Next Page:  Text Functions<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Logical functions return TRUE or FALSE and are sometimes called Boolean functions. Here is an introduction to how to use Boolean functions in Excel. TRUE\/FALSE functions The IF() function is used to create formulas that depend on a boolean outcome. Using IF() to control calculations Errors can occur in formulas (such as division by zero). &hellip; <a href=\"https:\/\/excelforgbs.com\/?page_id=184\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Logical Functions<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":30,"menu_order":10,"comment_status":"closed","ping_status":"closed","template":"","meta":{"nf_dc_page":"","_monsterinsights_skip_tracking":false,"footnotes":""},"class_list":["post-184","page","type-page","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/excelforgbs.com\/index.php?rest_route=\/wp\/v2\/pages\/184","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/excelforgbs.com\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/excelforgbs.com\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/excelforgbs.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/excelforgbs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=184"}],"version-history":[{"count":5,"href":"https:\/\/excelforgbs.com\/index.php?rest_route=\/wp\/v2\/pages\/184\/revisions"}],"predecessor-version":[{"id":329,"href":"https:\/\/excelforgbs.com\/index.php?rest_route=\/wp\/v2\/pages\/184\/revisions\/329"}],"up":[{"embeddable":true,"href":"https:\/\/excelforgbs.com\/index.php?rest_route=\/wp\/v2\/pages\/30"}],"wp:attachment":[{"href":"https:\/\/excelforgbs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=184"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}