Formulas Articles

Calculation setting in Google sheets
Formulas

How to Generate Random Numbers in Google Sheets?

A sequence of numbers is said to be statistically random when it does not contain any recognizable patterns. In statistics, randomness can be quite crucial. For example, one often needs to use random numbers when

SUM with INDIRECT
Formulas

How to Use the INDIRECT function in Google Sheets

There is a myriad of functions in Google Sheets, most of which are quite straightforward to understand. The INDIRECT function, however, is one of those Google Sheets functions that may not be that easy to