PV Function in Excel (Present Value)
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 …
Functions
Learn predefined excel functions used to calculate specific values. Excelbuddy covers dozens of functions with easy to follow demonstrations.
CONVERT Function in Excel
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 …
XLOOKUP Horizontal Lookup
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 …
ISERROR Function
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 …
PPMT Function
The PPMT Function in Excel is used to calculate the principle of a given loan payment. If all you a trying to determine is the principle of a …
NPER Function
The NPER Function in Excel is a financial function that returns the number of periods for a specified loan. The total periods of a loan are based on …
CUMPRINC Function
The CUMPRINC Function in Excel returns the cumulative principal paid on a loan between the start and end period. This is an excellent tool to quickly understand your …
YEARFRAC Function
The YEARFRAC function in Excel returns a decimal value that represents fractional years between two specified dates. Syntax: =YEARFRAC(start_date, end_date, [basis]) Arguments: start_date – The start date. end_date …
YEAR Function
The YEAR function in Excel returns a 4-digit number representing the year component of date. This function allows you to pull out the year from a date or …
