What is the NPER Function? The NPER Function is categorized under Excel Financial functions. The function helps calculate the number of periods that are required to pay off a loan or reach an investment goal through regular periodic payments and at a fixed interest rate. In financial analysis, we often wish to build a corporate…
What is the COUNTIF Function? The COUNTIF Function will count the number of cells that meet a specific criterion. The function is categorized under Excel Statistical functions. In financial analysis, the COUNTIF function is quite helpful. For example, when we want to count the number of times a salesperson exceeded their target, we can do this…
What is the ISTEXT Function? The ISTEXT Function is categorized under Excel Information functions. The function will test if a given value is a text string or not. If the given value is text, it will return TRUE, or if not, it will return FALSE. In doing financial analysis, if we want a particular file…
What is the MONTH Function? The MONTH Function is categorized under Excel DATE/TIME functions. The function will return the month portion of a date as a number. The number will be between 1 to 12. The MONTH function is available in all versions from MS Excel 2000. In financial analysis, we can use MONTH with…
What is the MINUTE Function? The MINUTE Function is categorized under Excel DATE/TIME functions. The function returns the minute component of a time as a number between 0-59. For example, it will return 49 for 1.49 PM. Formula =MINUTE(serial_number) The MINUTE function uses only one argument: Serial_number (required argument) – The time that contains the…
What is the SECOND Function? The SECOND Function is categorized under Excel DATE/TIME functions. The function returns the second component of a time as a number between 0-59. For example, it will return 49 for 1:19:49 PM. Formula =SECOND(serial_number) The SECOND function uses only one argument: Serial_number (required argument) – The time that contains the…
What is the HOUR Function? The HOUR Function is categorized under Excel DATE/TIME functions. The function returns the hour component of a time as a number between 0-23. For example, it will return 13 for 1:49 PM. Formula =HOUR(serial_number) This function uses only one argument: Serial_number (required argument) – The time that contains the hour…
What is the NOW Function? The NOW Function is categorized under Excel DATE/TIME functions. The function returns the current date and time. In financial analysis, the NOW function can be useful in preparing various KPI reports. We can use it to display the current date and time, as it will continually update each time the…
What is the PPMT Function? The PPMT Function is categorized under Excel Financial functions. The function will calculate the payment on the principal for a loan or an investment based on periodic, constant payments and a fixed interest rate for a given period of time. In financial analysis, the PPMT function is useful in understanding…
What is the MID Function? The MID Function is categorized under Excel TEXT functions. The function will return a specified number of characters from the middle of a given text string. While doing financial analysis, the MID function can be useful if we wish to extract characters from the middle of a specific text. Generally,…
