{"id":12604,"date":"2022-01-03T22:37:19","date_gmt":"2022-01-04T04:37:19","guid":{"rendered":"http:\/\/www.designandexecute.com\/designs\/?p=12604"},"modified":"2022-01-03T22:47:09","modified_gmt":"2022-01-04T04:47:09","slug":"nested-if-or-statements-in-excel","status":"publish","type":"post","link":"https:\/\/www.designandexecute.com\/designs\/nested-if-or-statements-in-excel\/","title":{"rendered":"Nested IF OR statements in Excel"},"content":{"rendered":"

IF with multiple OR conditions<\/h3>\n

=IF(OR(A2=””,B2=””, C2=””),”Incomplete”,””)<\/p>\n

Nested IF OR statements<\/h3>\n

You want to test a few sets of OR criteria and return different values depending on the results of those test criteria, write an individual IF formula for each set of “this OR that” criteria, and nest those IF’s into each other.<\/p>\n

Simple example<\/strong><\/p>\n

=IF(OR(A2=”apple”, A2=”orange”), “Fruit”, IF(OR(A2=”tomato”, A2=”cucumber”), “Vegetable”, “”))<\/p>\n

Building on a more realistic case<\/strong><\/p>\n

Example you want to conform all version countries to USA and Trinidad & Tobago<\/p>\n

=IF(OR(W3=”United States”,W3=”U.S.A”), “USA”, IF(OR(W3=”Trinidad”,W3=”Trinidad, W.I.”, W3=”Trinidad, WI”, W3=”Trinidad, West Indies”, W3=”Trinidad, W.I.”, W3=”Trinidad, WI”, W3=”Trinidad WI”, W3=”Trinidad, WI”, W3=”Trinidad and Tobago W.I.”, W3=”Trinidad & Tobago”), “Trinidad & Tobago”, W3))<\/p>\n

IF AND OR statement<\/h3>\n

example: You want buy MSFT or ABML if they are above $10<\/p>\n

=IF(AND(OR(A2=”MSFT”,A2=”ABML”), B2>10), “Buy”, “”)<\/p>\n

Case-sensitive IF OR formula<\/h3>\n

IF(OR(EXACT(cell,<\/em>“condition1<\/em>“), EXACT(cell,<\/em>“condition2<\/em>“)), value_if_true, value_if_false)<\/p>\n","protected":false},"excerpt":{"rendered":"

IF with multiple OR conditions =IF(OR(A2=””,B2=””, C2=””),”Incomplete”,””) Nested IF OR statements You want to test a few sets of OR criteria and return different values depending on the results of those test criteria, write an individual IF formula for each set of “this OR that” criteria, and nest those IF’s into each other. Simple example […]<\/p>\n","protected":false},"author":2,"featured_media":3831,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[43],"tags":[],"class_list":["post-12604","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-bi-excel"],"jetpack_featured_media_url":"https:\/\/www.designandexecute.com\/designs\/wp-content\/uploads\/2018\/04\/1200px-Microsoft_Excel_2013_logo.svg_.png","_links":{"self":[{"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/posts\/12604","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/comments?post=12604"}],"version-history":[{"count":4,"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/posts\/12604\/revisions"}],"predecessor-version":[{"id":12608,"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/posts\/12604\/revisions\/12608"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/media\/3831"}],"wp:attachment":[{"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/media?parent=12604"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/categories?post=12604"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/tags?post=12604"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}