Combined Use of IF, AND, OR Logical Functions in Google Doc Spreadsheet
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 for combined use of logical functions.
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. There is no change in the Syntax. 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.
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.
AND : This logical function is used to expand the use of IF function.
=AND(TRUE, TRUE) All arguments are TRUE, reslut is TRUE
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.
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.
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 is >49
3. Shows “Passed” if marks scored in any two subjects is >49
Go through the examples carefully several times. If you have any doubt drop it in comments below.
About Article Author
This is an ultimate tutorial for creating an advanced online form. Before coming to the tutorial few aspects about online
Google Doc Spreadsheet has lots of similar Excel functions to fulfill users data entry needs. Here is one useful tips for
We have a separate section on Info Inspired completely dedicated to Google Doc Spreadsheet Tutorials. In this post we can
Earlier we have learned how to create a Line Graph or Line Chart using Google Doc Spreadsheet. In this Google
When you have a long range of data arranged in row wise and want to change it into column wise,
Every systematic job will be based on a meticulous job schedule. But to achieve the goal, the schedule is not enough.