Google Sheets formulas articles

When you're carrying out data analysis, statistical measures help you to understand underlying trends. One of the most...

The INDIRECT function in Google Sheets takes in the cell address in the form of text and returns a cell reference. It...

The Google Sheets SORT function allows you to sort data and return the rows in ascending or descending order. It is...

The Google Sheets LOOKUP function searches through a row or column for a key and returns the value of the cell in a...

The GOOGLEFINANCE function allows you to import real-time financial and currency market data straight into Google...

The INDEX function in Google Sheets returns the value of a cell within an input range, relatively separated from the...

Combining QUERY with IMPORTRANGE allows you to pull in data from different spreadsheets and perform advanced queries...

Numbers are what comes to our mind when we think of spreadsheets applications. That is no surprise because they...

While working with strings on spreadsheets, we may have to do many operations such as trimming, extracting, and...

Spreadsheets have come a long way since they were first available, thereby making our lives a lot easier. Today they...

We know we use the spreadsheets applications generally to working with numbers. But we also have a good help in terms...

Spreadsheets of today are comprehensive tools that help us with everyday calculations. Be it elementary or advanced,...

In fields including but not limited statistics, science, gaming, cryptography etc. the use or random numbers is a...

Let us say we have a range of cells in a spreadsheet, and we want to know how many columns it has spread across. If...

While there are infinite rational numbers in mathematics, we don’t usually deal with all of them. That’s because, in...

While working with spreadsheets, we tend to come across many numbers that are rational. Some of them have more decimal...

While working with spreadsheets, we are bound to do many sorts of calculations. And we will, at times need to...

Number crunching is one of the primary activities that the spreadsheets applications are built for. We all know how to...

Analyzing the data leads us to multiple interpretations as to what the underlying nature is. And we have many...

In this post, learn how to calculate the normal cumulative distribution by using the NORMSDIST formula in Google...

We are aware of the important role, the normal cumulative distribution plays in the field of statistics. We can derive...

Data is what the spreadsheets are built for – and helping us analyze it is its primary goal. There are some key...

Spreadsheets are where most of us do our data analysis on. For that reason, we have many formulas and tools to aid us...

Various spreadsheets programs that we have been using have one main goal. To help us understand the underlying data....

While the first parameter accepts only range references, the second parameter can take both direct numbers as well as...

The TIME formula in Google Sheets accepts a given time through the hour, minute, and second component values, and...

In our day to day lives, we will be needing to do certain activities that may be time-sensitive. There can be business...

At times we may need to pick the hour from a time value. Possibly to use it with another formula that calculates an...