Learn predefined excel functions used to calculate specific values. Excelbuddy covers dozens of functions with easy to follow demonstrations.
This quick example will demonstrate how to split a string by a colon, semi-colon, comma, or delimiter in Excel. The example below will split a name from the …
Split String by colon, semi-colon, comma, or delimiter Read More »
The IPMT function in Excel is used to calculate the interest portion of a loan given a specified payment period. Syntax: Arguments: rate – Interest rate per period. …
The PV function in Excel returns the present value of an investment. The alternative function is the FV function (Future Value). The PV Function is used to obtain …
The CONVERT function in Excel converts a number from a specific measurement system to another. Some common uses of this function is converting various lengths. For example, you …
Learn to perform a horizontal lookup using XLOOKUP. With XLOOKUP, you no longer have to use the very limited HLOOKUP function. In the example below, we will perform …
The ISERROR function in Excel returns TRUE for any error type excel generates. This list of errors includes: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL! It is …
