Formulas Articles

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 for people who need to work with real-time finance or stock-related data. This single function gives you not only the current prices of stocks and conversion rates of currencies,

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

Not many people are familiar with the ADDRESS function, since many don’t understand why they need it or how it can help. In this tutorial, we will get you familiar with the Google Sheets ADDRESS