Three Major Finance Formulas: PV, FV, and YIELD
No field has benefited more from the impact of Excel’s implementation in 1987 than the finance field. This post will cover three major finance formulas: FV (future value), PV (present value), and YIELD (yield for interest paying securities like bonds). FV The foundational conecpt in finance is that a dollar...
Concatenate a Range with UDF
Often in Excel, you’ll want to combine the values of multiple cells into one cell. The fancy term for this is concatenation. There are two major ways to do this in Excel. The first of which is using the & operator to combine values together. Here’s a simple example using...
Use VLOOKUP to Replace Nested IF Statements
Basic logic is one of the most powerful features in Excel and allows you to do some neat tricks with simple formulas. The common IF statement allows for quick comparison and customizable output as a result. But, IF statements fall short when it comes to more complex logic, especially when...