Learn how to use important logical functions IF, AND, OR in Google Doc Spreadsheet. Logical functions are very easy to use if you get proper examples. You can find examples of logical functions online. But when you use logical functions in a combined form it expands the usefulness of some logical functions. It is rare to find simple examples of combined use of logical functions. Here I will explain you the combined use of IF, AND, OR logical functions in Google Sheets, the possible simplest way.
Some of you may familiar with Microsoft Excel Logical Functions. If you know if, and, or like logical functions in Excel you can similarly use it in Google Doc Spreadsheet also. There is no changes in the Syntax. It’s also relevant to combined use of IF, AND, OR logical functions. No changes in both spreadsheet applications.
It is easy to use logical functions individually. But logical functions are powerful when you use it in combined form. In this easy to follow Google Doc Spreadsheet tutorial we can learn how to use logical functions in combined form.
What are Spreadsheet Logical Functions?
I am not telling you the exact definition of logical functions. My intention is to give you a clear idea what logical functions are. With logical functions you can test the value of one cell and decide the result.
Logical Functions IF, AND, OR
In this example we are going to learn logical functions IF, AND, OR.
Use of Logical Function IF – How to
IF : This logical function is used to find whether an argument is true or false. If true this function brings one result and false another result.
Example : In Cell A1 put the value 50. Type any of the below formula in cell B1.
a) IF(A1>50,”Pass”, “Failed”)
b) IF(A1>50,”A1*20″, “A1*10”)
In the first logical test if the value in A1 is above 50, the Cell B1 shows “Pass”, else shows “Failed”
In the second logical test if the value in A1 is above 50, the Cell B1 get multiplies with 20, else get multiplies with 10.
Hope you understand this. Still doubt? Then switch to our dedicated IF function tutorial.
Use of Logical Function AND – How to
AND : This logical function is used to expand the use of IF function. So I will explain at later part of this tutorial.
=AND(TRUE, TRUE) All arguments are TRUE, result is TRUE
Use of Logical Function OR – How to
OR : Similarly above, this logical function is also used to expand the use of IF function.
=OR(TRUE,FALSE,TRUE) At least one argument is TRUE (TRUE)
I know you have doubt about AND, OR functions. You can learn it easily from the below example.
Learn IF, AND, OR logical functions easily from the below combined example.
How to use Logical Functions in Combined form in Excel Spreadsheet or Google Doc Spreadsheet?
You may have noticed that I’ve not detailed AND, OR logical functions above. It is because it is normally used to expand the usefulness of IF. So the below combined use of logical functions will clear your doubt about using these functions.
Similar to read! Simplified the Use of SUMIF function in Google Sheets
You may also interested in! How to use SUMIFS function in Google Sheets?
Download our eBook Now! [Google Sheets 20 proven tricks; that can boost your productivity – A must for all office goers!]
Example to Combined Use of IF, AND, OR Logical Functions
First type the contents as shown on the screenshot in a spread sheet. No matter whether you use Excel spreadsheet or Google Doc. You can omit Condition 1, Condition 2, Condition 3 because there we will apply logical functions later.
Hope you have typed the above data.
Now the formula
The first formula should be typed under condition 1, the second one under condition 2 and the final one under condition 3. If you copy and paste from the above, do rewrite the double quotes.
What these logical functions do?
1. Shows “Passed” if marks scored in any subject is >49
2. Shows “Passed” only if marks scored in all subjects are >49
3. Shows “Passed” if marks scored in any two subjects are >49
Note: Google Sheets SWITCH Function is more simpler than IF and IFS. Do you Know about it?
Go through the examples carefully several times. You should learn combined use of IF, AND, OR logical functions as it can greatly improve your spreadsheet skills. If you have any doubts drop it in comments below. Also you can get the similar results by using FILTER, AND, OR combination. Here instead of “Passed” or “Failed”, this combination filter the passed or failed students. Here is that New trendy tutorial.
Use of AND,OR with Google Sheets Filter Function [The above same sample data set used]