All the logical expressions in the AND function must be TRUE in order to get the value_if_true<\/b><\/li>\n<\/ul>\n[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
How to use the IF AND combination<\/h3>\n
I\u2019ll show a couple examples now in order to fully explain the functions. In this example, I have a list of people and their dietary information. I want to write a function that will tell me whether each person is a vegetarian and<\/i> has allergies.<\/p>\n
I can do this with the formula =IF(AND(D2=”Yes”,E2=”Yes”),”Yes”,”No”)<\/b>.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/02\/1.-IF-AND-example.png” alt=”if and excel 1″ title_text=”1. IF AND example” align=”center” _builder_version=”4.16″ _module_preset=”default” width=”640px” max_width=”640px” height=”440px” max_height=”440px” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
The logical expression here is AND(D2=”Yes”,E2=”Yes\u201d)<\/b>. This expression only evaluates as TRUE when both the values in column D (vegetarian) and<\/i> E (allergies) are Yes. If either of them are No, then the expression is FALSE.<\/p>\n
Note that you can use any of the logical operators in your logical expression. The list below shows the options you have.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/02\/2.-Logical-Operators.png” alt=”if and excel logical operators 2″ title_text=”2. Logical Operators” align=”center” _builder_version=”4.16″ _module_preset=”default” width=”640px” max_width=”640px” height=”440px” max_height=”440px” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Number between two values<\/h4>\n
Another way you can use the IF AND Excel function combination is when you want to find a number that\u2019s between two numbers.<\/p>\n
For example, if I want to see who is older than 19 but younger than 22, I can use the function =IF(AND(B2>19,B2<22),\"Yes\",\"No\")<\/b>.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/02\/3.-IF-AND-between-two-values.png” alt=”if and excel between two values 3″ title_text=”3. IF AND between two values” align=”center” _builder_version=”4.16″ _module_preset=”default” width=”640px” max_width=”640px” height=”440px” max_height=”440px” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Here I\u2019ve used two more of the logical operators shown previously (> and <). Using the AND function allows me to quickly set a range for each value by defining the upper and lower limits.<\/p>\n
I could also use the >= and <= operators to get the same result, by typing =IF(AND(B2>=20,B2<=21),\"Yes\",\"No\")<\/b>.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/02\/4.-IF-AND-greater-than_equal-to.png” alt=”if and excel greater than equal to 4″ title_text=”4. IF AND greater than_equal to” align=”center” _builder_version=”4.16″ _module_preset=”default” width=”640px” max_width=”640px” height=”440px” max_height=”440px” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Tips for using the IF AND function combination in Excel<\/h3>\n\n- The IF AND combination is a much cleaner alternative to nested IF statements. Sometimes nested IF\u2019s are necessary, but if you can use IF and AND instead, do it!<\/li>\n
- All logical expressions within the AND function must be true, otherwise it will return FALSE<\/li>\n
- If you want to get a TRUE result if any of your logical expressions is true, you can use the OR function instead of AND<\/li>\n<\/ul>\n
[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"
The IF function in Excel is extremely useful: it generates different outcomes depending on whether the input meets a certain criteria. But what if you want the input to meet multiple criteria instead of just one? That\u2019s where the AND function comes in. When combined, the IF AND Excel functions create an even more powerful […]<\/p>\n","protected":false},"author":40,"featured_media":31706,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[65],"tags":[39,48,28],"class_list":["post-31704","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-functions","tag-connections-t","tag-excel","tag-spreadsheets"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/31704","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/comments?post=31704"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/31704\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/31706"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=31704"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=31704"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=31704"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}