Formulas

Using VLOOKUP in Google Sheets is a great way to speed up your productivity when you need to pull data from another range or sheet. Many VLOOKUP users often wonder …

Learning to use the various date functions available in Google Sheets certainly takes time, but they can absolutely speed up your productivity when you need to accomplish certain things. One …

If you need to multiply matrices, the MMULT function is an easy way to do matrix multiplication. In this tutorial, I will show you how to use the MMULT function …

The IMPORTXML function is a powerful function that allows you to import data from structured data types like XML, HTML, CSV, TSV, RSS, and ATOM XML. If you want to …

The SWITCH function in Google Sheets is an easy way to create a switch statement in your spreadsheet. This function works similar to nesting multiple IF statements together, however, with …

If you are trying to calculate the present value of an investment that has a constant payment schedule and a constant interest rate, the PV function will come in handy. …

If you are trying to calculate the internal rate of return on an investment that has irregularly spaced cash flows, the XIRR function is exactly what you need. This kind …

The GOOGLEFINANCE function is a powerful function that can be used to get real-time financial and market-related data. With this function, you can quickly import the current prices of various …

If you want to know the future value of an investment that you make regular payments on that has a fixed interest rate, this kind of calculation can be done …

If you are used to working in Microsoft Excel, you may be familiar with the XLOOKUP function. When working in Google Sheets you may be wondering the best way to …