Formulas Articles

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

When working with numerical data, we often need to convert numbers to their absolute values. This is often useful in cases where we are working with distances or when we just want to make sure

Error handling is an important part of data processing. When you perform operations on data, there is almost always a possibility for errors. Good thing Google Sheets is well-equipped to detect these errors and notify

One of the most commonly used functions in Google Sheets is AVERAGE. It lets you easily get the numerical mean in a set of data. While it is a very helpful function, it still has

There are many functions in Google Sheets that serve the purpose of counting. For example, the COUNT function helps you count cells in a range containing a specific type of data, while the COUNTA function

The GOOGLEFINANCE function is an amazing tool used to make Google Sheets stock formulas for people who need to work with real-time finance data. This single function gives you not only the current prices of

For many Google Sheets users, even the fairly seasoned ones, the words ‘Array Formula’ can conjure nightmarish images. That’s why most people tend to steer clear of using array formulas in their worksheets. However, once

You’re trying to use a simple COUNTIF function, but you get an “#ERROR!” message instead. What does it mean and how can you fix it? Google Sheets doesn’t have a compiler. But when you ask