# Basic Google Sheets functions that will make you look like a pro

/
December 28, 2022 ## Overview:

Google Sheets is an incredibly powerful tool for organizing and manipulating data. It's an essential part of the Google Suite and is used by millions of people around the world for everything from personal finance to project management.

But, like any tool, the more you know about it, the more you can get out of it. That's why being a Google Sheets wizard is so important in today's job market. Whether you're an entrepreneur, a freelancer, or an employee, the ability to work with data and make informed decisions based on that data is a crucial skill.

So, let's dive into some of the most useful Google Sheets functions that can help you become, or at least look like, a pro. ## 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. 