.png)
.png)
The OR Function
The OR function is a logical function that returns TRUE if any of the conditions you specify are met. For example, if you want to know if a person is over 18 or has a college degree, you can use the OR function like this:
=OR(A2>18, B2="Yes")
This formula will return TRUE if either the value in cell A2 is greater than 18 or the value in cell B2 is "Yes".
The AND function
The AND function is similar, but it returns TRUE only if all of the conditions you specify are met. For example, if you want to know if a person is over 18 and has a college degree, you can use the AND function like this:
=AND(A2>18, B2="Yes")
This formula will return TRUE only if the value in cell A2 is greater than 18 and the value in cell B2 is "Yes".
The IF function
The IF function is a conditional function that allows you to specify different outcomes based on whether a condition is met or not. For example, if you want to assign a letter grade based on a student's test score, you can use the IF function like this:
=IF(A2>=90, "A", IF(A2>=80, "B", IF(A2>=70, "C", IF(A2>=60, "D", "F"))))
This formula will return "A" if the value in cell A2 is 90 or above, "B" if it's between 80 and 89, and so on.
The LIKE function
The LIKE function is a text function that allows you to search for a specific pattern within a string of text. For example, if you want to know if a person's email address ends in "@gmail.com", you can use the LIKE function like this:
=LIKE(A2, "*@gmail.com")
This formula will return TRUE if the value in cell A2 ends in "@gmail.com", and FALSE if it doesn't.
Increase your productivity
These are just a few examples of the many powerful functions available in Google Sheets. But, as you can see, they can be incredibly useful for analyzing and manipulating data.
And, if you want to save even more time and make your data even more reliable, check out Dokin, our powerful Google workspace add-on that allows you to connect data across sheets, slides, and docs. With Dokin, you can connect the values of Google Sheets cells, ranges or tables to strings of text in Google Slides and Google Docs, saving you time on manual data entry and ensuring that your Slides and Docs content is always up to date.
So, whether you're just starting out with Google Sheets or you're a seasoned pro, these functions and tools like Dokin can help you work more efficiently and make better decisions based on your data. So, give it a try and see how they can help you and let us know what you think!
.png)