Formulas Articles

As it’s a relatively recent addition to Microsoft Excel, you can’t currently use XLOOKUP in Google Sheets. But, you can use a few other functions or combinations to get similar results in Sheets. Join us

If you are maintaining a large data set such as daily expenses in Google Sheets, you might want to know the sum of expenses of a few consecutive days at the given time. For example,

Performing a T-Test in Google Sheets can save you a ton of time when you compare it to manually performing one. The only problem is the initial learning curve when learning how to do a

When working on a spreadsheet, you often encounter an issue where a formula isn’t working properly. Most of the time, this is due to the data not being in a proper format in the cells.

Google Sheets intelligently formats data correctly when you write it into a cell. However, often times we want to write our data in a different format than the one it automatically assigns. In these cases,

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