Formulas

There are many useful functions for doing division operations n Google Sheets. One lesser-known division function is the MOD function. In this tutorial, I will show you how to use …

In Google Sheets, getting #N/A errors can ruin your calculations because they will cause many of your formulas to break if you include them in any kind of calculation. Luckily …

If you need to find the internal rate of return, there is an easy way to do this in Google Sheets using the IRR function. In this tutorial, I will …

There are many functions in Google Sheets that you can use to check whether a value or cell contents meet certain criteria. One such function is the ISNUMBER function. Although …

Sometimes you might want to use Google Sheets to determine what day of the week a specific date is. That can be done with the WEEKDAY function. In this tutorial, …

There are a few different functions in Google Sheets that can be used to divide numbers. One useful way to do this is with the QUOTIENT function. This function will …

Google Sheets has many useful functions to help you evaluate numbers. One such function is the ISODD function. In this tutorial, I will show you how to use the ISODD …

Sometimes when doing formulas in Google Sheets you will end up with an #N/A error. This can make it difficult to do calculations with cells that are returning this error. …

If you need to check there a cell contains a date or not, there is a built-in function in Google Sheets that will do this. In this tutorial, I will …

In Google Sheets, you can combine VLOOKUP with other functions to do some neat things. For example, combining VLOOKUP with ARRAYFORMULA can be used to lookup multiple pieces of data …