Formulas Articles

Users who often work with large spreadsheets can find themselves needing to locate a value that fulfills a specific category, and doing this manually can be incredibly time-consuming. This is where the HLOOKUP function comes

Compound Interest is an important concept in banking and finance. This tutorial will help you understand this concept, show you how to compute it, and how to use Google Sheets to quickly find the compound

Searching a massive spreadsheet for specific text can be annoying when you do it manually. There isn’t an exact IF CONTAINS formula in Google Sheets. However, you can use a clever combination of a few

Google Forms provide a convenient way to collect data. You can use it to take quizzes and surveys, as well as collect feedback and registration information. However, its capabilities are not just limited to these. When

Correlation is quite a frequently encountered term when performing data analysis. If you have a basic idea of how two variables are correlated, you can decide whether you want to further explore and analyze the

Google Sheets is a feature-rich and easy-to-use spreadsheet tool with a fantastic set of features that allow users to create and manage their spreadsheets. Unfortunately, because it’s so powerful, it’s also quite complicated. Sometimes working

When creating spreadsheets in Google Sheets, you often have to repeat the same actions and inputs over and over again. There are several ways you can automate your work in Google Sheets with formulas, macros,

Named ranges can be a great way to increase productivity. It gives cell ranges a name — meaning that instead of having to use cell addresses every time in formulas, you can use the names in

Pi is an important irrational number for a plethora of applications. Pi is the ratio of the diameter and the circumference of the circle. Pi always has a value approximate to 3.14159. As the number