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 …
Functions
Learn predefined excel functions used to calculate specific values. Excelbuddy covers dozens of functions with easy to follow demonstrations.
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 …