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

Google Sheets
/
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.

Did you know?

Dokin makes your spreadsheets dynamic with live data from your systems.

Try for free

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!

Enjoyed this article?

Check out our blog or our help center for more.
Dokin, the data platform of modern business teams
Try for free

Jacopo Proietti

Co-founder @Dokin
Jacopo, a co-founder of Dokin, boasts 8 years in finance, having worked as a finance manager at Ogury and head of Financial Planning and Control at BlaBlaCar.
His passion for data integration led to the creation of Dokin, a game-changer for modern business teams. With customizable templates and built-in data connections, Dokin allows modern CMOs and CFOs to streamlines data reporting across Google Workspace applications.

More Stories

Marketing Data
Productivity tips
AARRR vs. RARRA: Which Growth Model Works Best for Your Product?
Marketing Data
Productivity tips
What is Return on Ad Spend (ROAS)?
Marketing Data
Productivity tips
Google Sheets
Growth Loops vs. AARRR Funnels: What’s the difference and How To Choose (2024)