AND and OR function in Google Sheets lets the user find out if the data in the spreadsheets meets certain criteria. You can sort your data using these logical functions by getting responses in TRUE or FALSE.
Using an AND function would give you “TRUE” as a response only if all of the arguments are true. While the case is different from OR function, you only need to have one true argument in the data and the answer would be given as TRUE.
You can use these functions separately or with other functions like IF. In this guide, you will learn how to use AND and OR function in Google Spreadsheets.
Learn How to Freeze Rows or Columns in Google Sheets
Using AND Function in Google Spreadsheets
You can use AND function alone or combined with other functions to get a logical result in TRUE or FALSE. Here’s how you can use this function:
- Launch the browser and go to Google Spread that has already been existing or create a new one.
- Click on an empty cell and type =AND(Argument A, Argument B), here replace Argument A and Argument B with the criteria you want to use. You need to have at least one argument for the AND function to work. Otherwise, you can have as many arguments as you want.
In the example below, the AND formula in cell A3 has two correct arguments and one that’s incorrect (F3=10, while F3 actually equals 3). This causes AND to respond with FALSE.
Using OR Function in Google Spreadsheets
Unlike AND function OR function just needs one Argument to be true to give out the result as TRUE. You can use the function alone or combined with other functions.
- Launch the browser and go to Google Spread that has already been existing or create a new one.
- Click on an empty cell and type =OR(Argument A, Argument B), replace the Argument A and Argument B with the choice of your own.
In the example below, the OR formulas in cells A4 and A5 returned a FALSE response because all three arguments in both formulas are incorrect.