Excel formulas, page 2

How to find and fix broken links in Excel

Excel cells may often link to other workbooks to pull relevant information from there. When a source workbook gets deleted, relocated, or damaged, external references to that file break down and your formulas start returning errors. Obviously, to fix the formulas, you need to find broken links. Continue reading

Excel FV function to calculate future value

Building your personal and corporate finances requires thorough planning. One of the most important factors of success is understanding how much an investment made today will grow to in the future. That is called the future value of investment, and this tutorial will teach you how to calculate it in Excel. Continue reading

5 ways to do VLOOKUP in Excel - which is fastest?

If your tables have only a few dozen rows, then most likely any method will be fast enough, and you won't notice the difference. But if the number of rows in your tables is measured in thousands, the correct choice of the function is crucial - the difference in performance can be more than 10 times! Continue reading

How to find top or bottom N values in Excel

Want to identify the highest or lowest values in a column or row? Need to return not only the values themselves but their names too? With this tutorial, you will learn how to find top 3, 5, 10 or n values in a dataset and retrieve matching data. Continue reading

Excel IF wildcard statement for partial text match

Trying to build an IF statement with wildcard text, but it fails every time? The problem is not in your formula but in the function itself - Excel IF does not support wildcard characters. However, there is a way to get it to work for partial text match, and this tutorial will teach you how. Continue reading