Formulas

Frequency distribution is something that can easily be done in Google Sheets with their built-in FREQUENCY function. This function will take your data and give you the distribution according to …

If you want to find the position of a string within a text, the FIND function in Google Sheets will come in handy. This useful text function allows you to …

There are some functions that are essential for anyone that regularly uses spreadsheet programs like Google Sheets or Microsoft Excel. The LEN function is one such function. This text function …

When you need to make financial calculations, a spreadsheet program like Google Sheets can greatly speed up your productivity. They have many built-in functions for common financial calculations. One such …

Google Sheets has a few useful financial functions for calculating things like the payments on a loan. One such function is called the PMT function. This can be used to …

If you want to add boolean values in Google Sheets, there is a great built-in function for this called the TRUE function. This can be useful in many different scenarios …

The SUBTOTAL function is a versatile function that is extremely useful when working with data. This is not a very well-known function, but by the end of this guide, you …

Google Sheets has many useful built-in functions for rounding down. The most commonly used rounding function I have covered in my previous post on rounding numbers in Google Sheets. But …

There are many useful rounding functions in Google Sheets to help you control how you want to round numbers. In one of my previous posts on how to round numbers …

Spreadsheet programs like Google Sheets can save you a lot of time when you are doing advanced calculations. They have a ton of mathematical functions to help you perform whatever …