{"id":999,"date":"2020-06-09T01:19:51","date_gmt":"2020-06-08T19:49:51","guid":{"rendered":"https:\/\/www.thewallstreetschool.com\/blog\/?p=999"},"modified":"2023-09-30T08:23:43","modified_gmt":"2023-09-30T02:53:43","slug":"usage-of-if-with-and-or-function-in-excel","status":"publish","type":"post","link":"https:\/\/www.thewallstreetschool.com\/blog\/usage-of-if-with-and-or-function-in-excel\/","title":{"rendered":"Usage of IF with AND & OR Function in Excel – Step by Step guide"},"content":{"rendered":"\r\n

In this article, we will learn about basic Logical Functions of MS Excel, namely IF, OR<\/strong> and AND<\/strong>. We will also learn how to use them in combinations such as IF with AND<\/strong> & IF with OR<\/strong><\/p>\r\n\r\n\r\n\r\n

Logical functions are the functions that check for a given condition. If the value satisfies the condition, the logic will display results according to the condition.<\/p>\r\n\r\n\r\n\r\n\r\n\r\n

IF Function<\/strong><\/h2>\r\n\r\n\r\n\r\n

The first function is IF <\/strong>function. If the value\/ formula satisfies a particular condition it will give results as per condition satisfaction.<\/p>\r\n\r\n\r\n\r\n

Syntax of IF function<\/strong><\/p>\r\n\r\n\r\n\r\n

IF(logical_test, [value_if_true], [value_if_false]) wherein<\/p>\r\n\r\n\r\n\r\n

\u2022 logical_test<\/strong>: The condition that need to be evaluated<\/p>\r\n\r\n\r\n\r\n

\u2022 value_if_true<\/strong>: The value that you want to print if the condition is satisfied<\/p>\r\n\r\n\r\n\r\n

\u2022 value_if_false<\/strong>: The value that you want to be returned if the condition is not satisfied<\/p>\r\n\r\n\r\n\r\n

For Example –<\/p>\r\n\r\n\r\n\r\n

\r\n
https:\/\/vimeo.com\/427135082<\/div>\r\n<\/figure>\r\n\r\n\r\n\r\n

AND Function<\/strong><\/h2>\r\n\r\n\r\n\r\n

The second function is AND<\/strong>. AND function returns \u201cTRUE\u201d or \u201cFALSE\u201d. If all the conditions in the formula is satisfied, it will return \u201cTRUE\u201d else it will return \u201cFALSE\u201d.<\/p>\r\n\r\n\r\n\r\n

Syntax of AND function<\/strong><\/p>\r\n\r\n\r\n\r\n

AND(logical1, [logical2], \u2026) wherein<\/p>\r\n\r\n\r\n\r\n

\u2022 logical1<\/strong>: The first condition that you want to check that can be either TRUE or FALSE<\/p>\r\n\r\n\r\n\r\n

\u2022 logical2<\/strong>, logical3<\/strong> \u2026: Additional conditions that you want to check that can be either TRUE or FALSE. You can check maximum of 255 conditions<\/p>\r\n\r\n\r\n\r\n

For Example –<\/p>\r\n\r\n\r\n\r\n

\r\n
https:\/\/vimeo.com\/427134982<\/div>\r\n<\/figure>\r\n\r\n\r\n\r\n

OR Function<\/strong><\/h2>\r\n\r\n\r\n\r\n

The Third function is OR<\/strong>. OR function returns \u201cTRUE\u201d or \u201cFALSE\u201d. If one of the conditions in the formula is satisfied, it will return \u201cTRUE\u201d else it will return \u201cFALSE\u201d.<\/p>\r\n\r\n\r\n\r\n

Syntax of OR function<\/strong><\/p>\r\n\r\n\r\n\r\n

OR(logical1, [logical2], \u2026) wherein<\/p>\r\n\r\n\r\n\r\n

\u2022 logical1<\/strong>: The first condition that you want to check that can be either TRUE or FALSE<\/p>\r\n\r\n\r\n\r\n

\u2022 logical2<\/strong>, logical3<\/strong> \u2026: Additional conditions that you want to check that can be either TRUE or FALSE. You can check maximum of 255 conditions<\/p>\r\n\r\n\r\n\r\n

For Example –<\/p>\r\n\r\n\r\n\r\n

\r\n
https:\/\/vimeo.com\/427134822<\/div>\r\n<\/figure>\r\n\r\n\r\n\r\n

Usage of IF with AND <\/strong><\/h2>\r\n\r\n\r\n\r\n

IF AND combination is used when there are multiple conditions which we want to test and if all the conditions are true it gives us the result as per condition satisfaction<\/p>\r\n\r\n\r\n\r\n

Syntax of IF-AND Combination<\/strong><\/p>\r\n\r\n\r\n\r\n

IF(AND(logical1, [logical2], \u2026), [value_if_true], [value_if_false])\u00a0<\/p>\r\n\r\n\r\n\r\n

For Example –<\/p>\r\n\r\n\r\n\r\n

\r\n
https:\/\/vimeo.com\/427135342<\/div>\r\n<\/figure>\r\n\r\n\r\n\r\n

Usage of IF with OR<\/h2>\r\n\r\n\r\n\r\n

IF OR combination is used when there are multiple conditions which we want to test and if one of the conditions are true it gives us the result as per condition satisfaction<\/p>\r\n\r\n\r\n\r\n

Syntax of IF-OR Combination<\/strong><\/p>\r\n\r\n\r\n\r\n

IF(OR(logical1, [logical2], \u2026), [value_if_true], [value_if_false])\u00a0<\/p>\r\n\r\n\r\n\r\n

For Example –<\/p>\r\n\r\n\r\n\r\n

\r\n
https:\/\/vimeo.com\/427131804<\/div>\r\n<\/figure>\r\n\r\n\r\n","protected":false},"excerpt":{"rendered":"

In this article, we will learn about basic Logical Functions of MS Excel, namely IF, OR and AND. We will also learn how to use<\/p>\n","protected":false},"author":4,"featured_media":969,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[28],"tags":[],"class_list":["post-999","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-microsoft-excel"],"_links":{"self":[{"href":"https:\/\/www.thewallstreetschool.com\/blog\/wp-json\/wp\/v2\/posts\/999","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.thewallstreetschool.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.thewallstreetschool.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.thewallstreetschool.com\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.thewallstreetschool.com\/blog\/wp-json\/wp\/v2\/comments?post=999"}],"version-history":[{"count":0,"href":"https:\/\/www.thewallstreetschool.com\/blog\/wp-json\/wp\/v2\/posts\/999\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.thewallstreetschool.com\/blog\/wp-json\/wp\/v2\/media\/969"}],"wp:attachment":[{"href":"https:\/\/www.thewallstreetschool.com\/blog\/wp-json\/wp\/v2\/media?parent=999"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.thewallstreetschool.com\/blog\/wp-json\/wp\/v2\/categories?post=999"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.thewallstreetschool.com\/blog\/wp-json\/wp\/v2\/tags?post=999"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}