{"id":250,"date":"2022-12-01T20:31:54","date_gmt":"2022-12-01T20:31:54","guid":{"rendered":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/chapter\/logical-functions-and-formulas\/"},"modified":"2022-12-01T20:31:54","modified_gmt":"2022-12-01T20:31:54","slug":"logical-functions-and-formulas","status":"publish","type":"chapter","link":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/chapter\/logical-functions-and-formulas\/","title":{"raw":"Logical Functions and Formulas","rendered":"Logical Functions and Formulas"},"content":{"raw":"\n<div class=\"textbox learning-objectives\">\n<h3>Learning Outcomes<\/h3>\n<ul>\n \t<li>Use logical functions and formulas<\/li>\n<\/ul>\n<\/div>\nExcel logic functions evaluate whether the statement and data are considered true or false according to how the formula is established. We will cover the top used Excel logical functions in this section. Exactly like the financial functions, you can use the Formulas tab as before to insert the function or you can begin by typing an equal sign in a cell.\n<h2>Nested IF<\/h2>\nTaking an IF function and adding more than one logic test inside the IF function. In other words, start with and IF function and add another IF function inside the original IF function. A Nested IF formula looks like this: <strong>=IF(logical_test,[value_if_true],[value_if_false],IF(logical_test,[value_if_true],[value_if_false]))<\/strong>\n\nPreviously, you learned how to use the IF function as a logical way to test your data. Let\u2019s consider that we want to see two variables run at once to create a logical outcome. We\u2019ll now look at Regional Sales for five salespeople over a year and see if they meet the requirements for an annual commission and what the commission amount would be.\n<div class=\"textbox exercises\">\n<h3>Note<\/h3>\nTwo shortcuts for locking down a cell to make it absolute instead of relative. You\u2019ll need to know these to work faster through creating formulas.\n<ul>\n \t<li style=\"font-weight: 400;\">Short cut key F4 automatically adds in $ to a cell location information to lock it down and make it absolute to stop it from changing as it is dragged into other cells or ranges (e.g. $D$3).<\/li>\n \t<li style=\"font-weight: 400;\">Name Range locks down a cell like $. To create a Name Range, highlight the cell, click on the Formulas tab, Define Name button. After the dialog box opens, name the location (no spaces) to make it unique for navigation or for formulas (e.g. Commission_Rate).<\/li>\n<\/ul>\n<\/div>\nWith a sales spreadsheet open, look at the tiered commission structure. There are two possibilities to earn commission. A Nested IF function is a perfect formula to calculate which salesperson receives how much commission.\n\nFollow these steps to create a Nested IF function:\n<ol>\n \t<li style=\"font-weight: 400;\">First let\u2019s define names for the two types of commissions as this will make it easier to distinguish in the formula. Select the 20% cell and click on the Formula tab, Define Name button and name it Commission_Rate_20. Follow the same steps to name the 10% commission cell too.\n<img class=\"alignnone wp-image-3020 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/20194055\/Module_8_Statistical_Logical_NIF_1.png\" alt=\"Excel screenshot of the define names button under the Formulas tab.\" width=\"723\" height=\"458\"> <img class=\"alignnone wp-image-3021 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/20194100\/Module_8_Statistical_Logical_NIF_1.1.png\" alt=\"Excel screenshot of filling in the information for defining a name for the commission amount.\" width=\"719\" height=\"593\"><\/li>\n \t<li style=\"font-weight: 400;\">Select the first cell under the commission heading and begin typing =IF, then hit the Tab key and a bracket will automatically appear displaying the logic formula for an IF function.\n<img class=\"alignnone wp-image-3022 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/20194128\/Module_8_Statistical_Logical_NIF_1.2.png\" alt=\"Excel screenshot showing what should be entered into the IF function to complete the logic formula.\" width=\"725\" height=\"407\"><\/li>\n \t<li style=\"font-weight: 400;\">Select the total sales for Henry (G4) and type in whether the total sales is less than or equal to the sales goal (G4&gt;=I2). Be sure to hit the F4 button and the absolute $ will fill I2 so it will not change in any way if the formula is moved ($I$2), then type a comma.\n<img class=\"alignnone wp-image-3023 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/20194148\/Module_8_Statistical_Logical_NIF_1.3.png\" alt=\"Excel screenshot displaying the inputs for the IF function formulas.\" width=\"711\" height=\"301\"><\/li>\n \t<li style=\"font-weight: 400;\">The next portion of the formula is for the percentage of commission to be paid if the goal has been reached. After the comma, choose the sales total again (F4) multiplied by the commission percentage by selecting the name you created earlier (F4*Commession_Rate_20), then a comma to separate the next part of the formula.\n<img class=\"alignnone wp-image-3024 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/20194217\/Module_8_Statistical_Logical_NIF_1.4.png\" alt=\"Excel screenshot displaying the inputs for the IF function formulas adding the Comission_Rate_20 name.\" width=\"724\" height=\"283\"><\/li>\n \t<li style=\"font-weight: 400;\">The next portion of the formula is for the other percentage of commission to be paid if that lower goal has been met. After the comma, type another IF and hit the Tab key. Create the same formula again but use the Commission_Rate_10 this time and at the end a comma.\n<img class=\"alignnone wp-image-3025 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/20194243\/Module_8_Statistical_Logical_NIF_1.5.png\" alt=\"Excel screenshot displaying the inputs for the IF function formulas adding the Comission_Rate_10 name.\" width=\"903\" height=\"285\"><\/li>\n \t<li style=\"font-weight: 400;\">The last portion of the formula is asking what to do if the logic comes back as a false answer. In this case, it will return a 0. Now finish with two end parentheses, one turns red indicating the second IF function, and then an additional end parenthesis to enclose the entire function begun with the first IF function.\n<img class=\"alignnone wp-image-3026 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/20194305\/Module_8_Statistical_Logical_NIF_1.6.png\" alt=\"Excel screenshot displaying the inputs for the IF function formulas adding 0 if the answer returns false.\" width=\"889\" height=\"283\"><\/li>\n \t<li style=\"font-weight: 400;\">Now copy the formula down the column all the way to the last salesperson\u2019s total. These are the commissions paid based on the Nested IF formulas created. A nice logical function to make a more difficult task easier in a spreadsheet.<\/li>\n<\/ol>\n<img class=\"alignnone wp-image-3027 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/20194324\/Module_8_Statistical_Logical_NIF_1.7.png\" alt=\"Excel screenshot displaying the commission results using the Nested IF function.\" width=\"731\" height=\"303\">\n<h2>AND<\/h2>\nThis function returns TRUE if all the arguments in its formula are TRUE and returns FALSE if any of the conditions are false. The Excel formula for this is<strong> =AND(logical1,[logical2],\u2026)<\/strong>.\n\nIn this example the AND function returns TRUE if the first score is greater than or equal to 60 and the second score is greater than or equal to 90, otherwise it returns FALSE.\n\n<img class=\"alignnone wp-image-3028 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/20194340\/Module_8_Statistical_Logical_AND_1.png\" alt=\"Excel screenshot displaying the inputs for the AND function formulas adding the Comission_Rate_10 name.\" width=\"415\" height=\"190\">\n<h2>OR<\/h2>\nThe OR function returns TRUE if any of the arguments are TRUE. The Excel formula for this is <strong>=OR(logical1,[logical2],\u2026)<\/strong>.\n\nIn this example the AND function returns TRUE if the first score is greater than or equal to 65 and the second score is greater than or equal to 100, otherwise it returns FALSE.\n\n<img class=\"alignnone wp-image-3029 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/20194355\/Module_8_Statistical_Logical_OR_1.png\" alt=\"Excel screenshot displaying the logical return for the OR function in a table.\" width=\"398\" height=\"194\">\n<h2>IFERROR<\/h2>\nIf your formula errors out, you can add in a value you specify how you would like it displayed. This logic function is beneficial to use if you occasionally run into errors and wish to have a cleaner looking spreadsheet to present.\n\nThe Excel formula for this is <strong>=IFERROR(value,value_if_error)<\/strong>.\n\nIn this example there is an error in the Profit Margin row that is displayed at #DIV\/0!. By using the IFERROR function an error like this can be displayed as a zero or even as text like \u201cOuch\u201d if so desired. Here is what it looks like:\n\n<img class=\"alignnone wp-image-3030 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/20194436\/Module_8_Statistical_Logical_IFERROR_1.png\" alt=\"Excel screenshot displaying the logical return for the IFERROR function in a table.\" width=\"468\" height=\"350\"> <img class=\"alignnone wp-image-3031 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/20194440\/Module_8_Statistical_Logical_IFERROR_2.png\" alt=\"Excel screenshot displaying the logical return for the IFERROR function in a table.\" width=\"480\" height=\"338\">\n<div class=\"textbox tryit\">\n<h3>Practice Question<\/h3>\nhttps:\/\/assess.lumenlearning.com\/practice\/0eba0eb0-927a-40d5-ab13-0903d7a99bf1\n\nhttps:\/\/assess.lumenlearning.com\/practice\/2d7203a0-3a21-4e8e-b4fc-cf2dc84563a4\n\n<\/div>\n<h2>Contribute!<\/h2><div style=\"margin-bottom: 8px;\">Did you have an idea for improving this content? We\u2019d love your input.<\/div><a href=\"https:\/\/docs.google.com\/document\/d\/1jwJOunqxLqxqeUBNJIgaCzQYZOHfTCEJce8_QUtFRCQ\" target=\"_blank\" style=\"font-size: 10pt; font-weight: 600; color: #077fab; text-decoration: none; border: 2px solid #077fab; border-radius: 7px; padding: 5px 25px; text-align: center; cursor: pointer; line-height: 1.5em;\">Improve this page<\/a><a style=\"margin-left: 16px;\" target=\"_blank\" href=\"https:\/\/docs.google.com\/document\/d\/1vy-T6DtTF-BbMfpVEI7VP_R7w2A4anzYZLXR8Pk4Fu4\">Learn More<\/a>\n","rendered":"<div class=\"textbox learning-objectives\">\n<h3>Learning Outcomes<\/h3>\n<ul>\n<li>Use logical functions and formulas<\/li>\n<\/ul>\n<\/div>\n<p>Excel logic functions evaluate whether the statement and data are considered true or false according to how the formula is established. We will cover the top used Excel logical functions in this section. Exactly like the financial functions, you can use the Formulas tab as before to insert the function or you can begin by typing an equal sign in a cell.<\/p>\n<h2>Nested IF<\/h2>\n<p>Taking an IF function and adding more than one logic test inside the IF function. In other words, start with and IF function and add another IF function inside the original IF function. A Nested IF formula looks like this: <strong>=IF(logical_test,[value_if_true],[value_if_false],IF(logical_test,[value_if_true],[value_if_false]))<\/strong><\/p>\n<p>Previously, you learned how to use the IF function as a logical way to test your data. Let\u2019s consider that we want to see two variables run at once to create a logical outcome. We\u2019ll now look at Regional Sales for five salespeople over a year and see if they meet the requirements for an annual commission and what the commission amount would be.<\/p>\n<div class=\"textbox exercises\">\n<h3>Note<\/h3>\n<p>Two shortcuts for locking down a cell to make it absolute instead of relative. You\u2019ll need to know these to work faster through creating formulas.<\/p>\n<ul>\n<li style=\"font-weight: 400;\">Short cut key F4 automatically adds in $ to a cell location information to lock it down and make it absolute to stop it from changing as it is dragged into other cells or ranges (e.g. $D$3).<\/li>\n<li style=\"font-weight: 400;\">Name Range locks down a cell like $. To create a Name Range, highlight the cell, click on the Formulas tab, Define Name button. After the dialog box opens, name the location (no spaces) to make it unique for navigation or for formulas (e.g. Commission_Rate).<\/li>\n<\/ul>\n<\/div>\n<p>With a sales spreadsheet open, look at the tiered commission structure. There are two possibilities to earn commission. A Nested IF function is a perfect formula to calculate which salesperson receives how much commission.<\/p>\n<p>Follow these steps to create a Nested IF function:<\/p>\n<ol>\n<li style=\"font-weight: 400;\">First let\u2019s define names for the two types of commissions as this will make it easier to distinguish in the formula. Select the 20% cell and click on the Formula tab, Define Name button and name it Commission_Rate_20. Follow the same steps to name the 10% commission cell too.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3020 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/20194055\/Module_8_Statistical_Logical_NIF_1.png\" alt=\"Excel screenshot of the define names button under the Formulas tab.\" width=\"723\" height=\"458\" \/> <img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3021 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/20194100\/Module_8_Statistical_Logical_NIF_1.1.png\" alt=\"Excel screenshot of filling in the information for defining a name for the commission amount.\" width=\"719\" height=\"593\" \/><\/li>\n<li style=\"font-weight: 400;\">Select the first cell under the commission heading and begin typing =IF, then hit the Tab key and a bracket will automatically appear displaying the logic formula for an IF function.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3022 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/20194128\/Module_8_Statistical_Logical_NIF_1.2.png\" alt=\"Excel screenshot showing what should be entered into the IF function to complete the logic formula.\" width=\"725\" height=\"407\" \/><\/li>\n<li style=\"font-weight: 400;\">Select the total sales for Henry (G4) and type in whether the total sales is less than or equal to the sales goal (G4&gt;=I2). Be sure to hit the F4 button and the absolute $ will fill I2 so it will not change in any way if the formula is moved ($I$2), then type a comma.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3023 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/20194148\/Module_8_Statistical_Logical_NIF_1.3.png\" alt=\"Excel screenshot displaying the inputs for the IF function formulas.\" width=\"711\" height=\"301\" \/><\/li>\n<li style=\"font-weight: 400;\">The next portion of the formula is for the percentage of commission to be paid if the goal has been reached. After the comma, choose the sales total again (F4) multiplied by the commission percentage by selecting the name you created earlier (F4*Commession_Rate_20), then a comma to separate the next part of the formula.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3024 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/20194217\/Module_8_Statistical_Logical_NIF_1.4.png\" alt=\"Excel screenshot displaying the inputs for the IF function formulas adding the Comission_Rate_20 name.\" width=\"724\" height=\"283\" \/><\/li>\n<li style=\"font-weight: 400;\">The next portion of the formula is for the other percentage of commission to be paid if that lower goal has been met. After the comma, type another IF and hit the Tab key. Create the same formula again but use the Commission_Rate_10 this time and at the end a comma.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3025 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/20194243\/Module_8_Statistical_Logical_NIF_1.5.png\" alt=\"Excel screenshot displaying the inputs for the IF function formulas adding the Comission_Rate_10 name.\" width=\"903\" height=\"285\" \/><\/li>\n<li style=\"font-weight: 400;\">The last portion of the formula is asking what to do if the logic comes back as a false answer. In this case, it will return a 0. Now finish with two end parentheses, one turns red indicating the second IF function, and then an additional end parenthesis to enclose the entire function begun with the first IF function.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3026 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/20194305\/Module_8_Statistical_Logical_NIF_1.6.png\" alt=\"Excel screenshot displaying the inputs for the IF function formulas adding 0 if the answer returns false.\" width=\"889\" height=\"283\" \/><\/li>\n<li style=\"font-weight: 400;\">Now copy the formula down the column all the way to the last salesperson\u2019s total. These are the commissions paid based on the Nested IF formulas created. A nice logical function to make a more difficult task easier in a spreadsheet.<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3027 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/20194324\/Module_8_Statistical_Logical_NIF_1.7.png\" alt=\"Excel screenshot displaying the commission results using the Nested IF function.\" width=\"731\" height=\"303\" \/><\/p>\n<h2>AND<\/h2>\n<p>This function returns TRUE if all the arguments in its formula are TRUE and returns FALSE if any of the conditions are false. The Excel formula for this is<strong> =AND(logical1,[logical2],\u2026)<\/strong>.<\/p>\n<p>In this example the AND function returns TRUE if the first score is greater than or equal to 60 and the second score is greater than or equal to 90, otherwise it returns FALSE.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3028 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/20194340\/Module_8_Statistical_Logical_AND_1.png\" alt=\"Excel screenshot displaying the inputs for the AND function formulas adding the Comission_Rate_10 name.\" width=\"415\" height=\"190\" \/><\/p>\n<h2>OR<\/h2>\n<p>The OR function returns TRUE if any of the arguments are TRUE. The Excel formula for this is <strong>=OR(logical1,[logical2],\u2026)<\/strong>.<\/p>\n<p>In this example the AND function returns TRUE if the first score is greater than or equal to 65 and the second score is greater than or equal to 100, otherwise it returns FALSE.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3029 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/20194355\/Module_8_Statistical_Logical_OR_1.png\" alt=\"Excel screenshot displaying the logical return for the OR function in a table.\" width=\"398\" height=\"194\" \/><\/p>\n<h2>IFERROR<\/h2>\n<p>If your formula errors out, you can add in a value you specify how you would like it displayed. This logic function is beneficial to use if you occasionally run into errors and wish to have a cleaner looking spreadsheet to present.<\/p>\n<p>The Excel formula for this is <strong>=IFERROR(value,value_if_error)<\/strong>.<\/p>\n<p>In this example there is an error in the Profit Margin row that is displayed at #DIV\/0!. By using the IFERROR function an error like this can be displayed as a zero or even as text like \u201cOuch\u201d if so desired. Here is what it looks like:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3030 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/20194436\/Module_8_Statistical_Logical_IFERROR_1.png\" alt=\"Excel screenshot displaying the logical return for the IFERROR function in a table.\" width=\"468\" height=\"350\" \/> <img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3031 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/20194440\/Module_8_Statistical_Logical_IFERROR_2.png\" alt=\"Excel screenshot displaying the logical return for the IFERROR function in a table.\" width=\"480\" height=\"338\" \/><\/p>\n<div class=\"textbox tryit\">\n<h3>Practice Question<\/h3>\n<p>\t<iframe id=\"assessment_practice_0eba0eb0-927a-40d5-ab13-0903d7a99bf1\" class=\"resizable\" src=\"https:\/\/assess.lumenlearning.com\/practice\/0eba0eb0-927a-40d5-ab13-0903d7a99bf1?iframe_resize_id=assessment_practice_id_0eba0eb0-927a-40d5-ab13-0903d7a99bf1\" frameborder=\"0\" style=\"border:none;width:100%;height:100%;min-height:300px;\"><br \/>\n\t<\/iframe><\/p>\n<p>\t<iframe id=\"assessment_practice_2d7203a0-3a21-4e8e-b4fc-cf2dc84563a4\" class=\"resizable\" src=\"https:\/\/assess.lumenlearning.com\/practice\/2d7203a0-3a21-4e8e-b4fc-cf2dc84563a4?iframe_resize_id=assessment_practice_id_2d7203a0-3a21-4e8e-b4fc-cf2dc84563a4\" frameborder=\"0\" style=\"border:none;width:100%;height:100%;min-height:300px;\"><br \/>\n\t<\/iframe><\/p>\n<\/div>\n<h2>Contribute!<\/h2>\n<div style=\"margin-bottom: 8px;\">Did you have an idea for improving this content? We\u2019d love your input.<\/div>\n<p><a href=\"https:\/\/docs.google.com\/document\/d\/1jwJOunqxLqxqeUBNJIgaCzQYZOHfTCEJce8_QUtFRCQ\" target=\"_blank\" style=\"font-size: 10pt; font-weight: 600; color: #077fab; text-decoration: none; border: 2px solid #077fab; border-radius: 7px; padding: 5px 25px; text-align: center; cursor: pointer; line-height: 1.5em;\">Improve this page<\/a><a style=\"margin-left: 16px;\" target=\"_blank\" href=\"https:\/\/docs.google.com\/document\/d\/1vy-T6DtTF-BbMfpVEI7VP_R7w2A4anzYZLXR8Pk4Fu4\">Learn More<\/a><\/p>\n\n\t\t\t <section class=\"citations-section\" role=\"contentinfo\">\n\t\t\t <h3>Candela Citations<\/h3>\n\t\t\t\t\t <div>\n\t\t\t\t\t\t <div id=\"citation-list-250\">\n\t\t\t\t\t\t\t <div class=\"licensing\"><div class=\"license-attribution-dropdown-subheading\">CC licensed content, Original<\/div><ul class=\"citation-list\"><li>Logical Functions and Formulas. <strong>Authored by<\/strong>: Sherri Pendleton. <strong>Provided by<\/strong>: Lumen Learning. <strong>License<\/strong>: <em><a target=\"_blank\" rel=\"license\" href=\"https:\/\/creativecommons.org\/licenses\/by\/4.0\/\">CC BY: Attribution<\/a><\/em><\/li><\/ul><\/div>\n\t\t\t\t\t\t <\/div>\n\t\t\t\t\t <\/div>\n\t\t\t <\/section>","protected":false},"author":503070,"menu_order":15,"template":"","meta":{"_candela_citation":"[{\"type\":\"original\",\"description\":\"Logical Functions and Formulas\",\"author\":\"Sherri Pendleton\",\"organization\":\"Lumen Learning\",\"url\":\"\",\"project\":\"\",\"license\":\"cc-by\",\"license_terms\":\"\"}]","CANDELA_OUTCOMES_GUID":"251ce209-5e67-4bc1-b0c6-9e88b645c93b, 32721dd7-b551-4849-a241-532f488f1318","pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":[],"pb_section_license":""},"chapter-type":[],"contributor":[],"license":[],"class_list":["post-250","chapter","type-chapter","status-publish","hentry"],"part":235,"_links":{"self":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/chapters\/250","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/chapters"}],"about":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/types\/chapter"}],"author":[{"embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/users\/503070"}],"version-history":[{"count":0,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/chapters\/250\/revisions"}],"part":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/parts\/235"}],"metadata":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/chapters\/250\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/media?parent=250"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/chapter-type?post=250"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/contributor?post=250"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/license?post=250"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}