{"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":"2020-06-09T01:19:51","modified_gmt":"2020-06-08T19:49:51","slug":"usage-of-if-with-and-or-function-in-excel","status":"publish","type":"post","link":"https:\/\/www.thewallstreetschool.com\/stg-new\/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":"\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>\n\n\n\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>\n\n\n\n\n\n

IF Function<\/strong><\/h2>\n\n\n\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>\n\n\n\n

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

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

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

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

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

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

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

AND Function<\/strong><\/h2>\n\n\n\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>\n\n\n\n

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

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

\u2022 logical1<\/strong>: The first condition that you want to check that can be either TRUE or FALSE<\/p>\n\n\n\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>\n\n\n\n

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

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

OR Function<\/strong><\/h2>\n\n\n\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>\n\n\n\n

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

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

\u2022 logical1<\/strong>: The first condition that you want to check that can be either TRUE or FALSE<\/p>\n\n\n\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>\n\n\n\n

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

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

Usage of IF with AND <\/strong><\/h2>\n\n\n\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>\n\n\n\n

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

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

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

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

Usage of IF with OR<\/h2>\n\n\n\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>\n\n\n\n

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

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

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

\n
https:\/\/vimeo.com\/427131804<\/div>\n<\/figure>\n\n\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 them in combinations such as IF with AND & IF with OR Logical functions are the functions that check for a given condition. If the value satisfies the condition, the […]<\/p>\n","protected":false},"author":45,"featured_media":969,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[798],"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\/stg-new\/wp-json\/wp\/v2\/posts\/999","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.thewallstreetschool.com\/stg-new\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.thewallstreetschool.com\/stg-new\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.thewallstreetschool.com\/stg-new\/wp-json\/wp\/v2\/users\/45"}],"replies":[{"embeddable":true,"href":"https:\/\/www.thewallstreetschool.com\/stg-new\/wp-json\/wp\/v2\/comments?post=999"}],"version-history":[{"count":0,"href":"https:\/\/www.thewallstreetschool.com\/stg-new\/wp-json\/wp\/v2\/posts\/999\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.thewallstreetschool.com\/stg-new\/wp-json\/wp\/v2\/media\/969"}],"wp:attachment":[{"href":"https:\/\/www.thewallstreetschool.com\/stg-new\/wp-json\/wp\/v2\/media?parent=999"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.thewallstreetschool.com\/stg-new\/wp-json\/wp\/v2\/categories?post=999"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.thewallstreetschool.com\/stg-new\/wp-json\/wp\/v2\/tags?post=999"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}