What is the ISREF Function? The ISREF Function is categorized under Excel Information functions. The function will test if a given value is a reference or not. If the given value is a reference, it will return TRUE. Otherwise, it will return FALSE. In financial analysis, let’s assume we need to create 21 worksheets in a…
What is the INFO Function? The INFO Function is categorized under Excel Information functions. The function helps extract information about the current operating environment, including the Excel release version and operating system. Imagine a situation wherein you are working as a remote financial analyst and receive weekly data, in the form of Excel files, from…
What is the YEARFRAC Function? The YEARFRAC Function is categorized under Excel DATE/TIME functions. YEARFRAC will return the number of days between two dates as a year fraction, in decimal form, in Excel. In financial analysis, one can use the function to, for example, calculate a portion of annual revenues. Formula =YEARFRAC(start_date, end_date, [basis]) The…
What is the PMT Function? The PMT Function is categorized under financial Excel functions. The function helps calculate the total payment (principal and interest) required to settle a loan or an investment with a fixed interest rate over a specific time period. Formula =PMT(rate, nper, pv, [fv], [type]) The PMT function uses the following arguments:…
The COUNTIFS function in Excel counts the number of cells that meet one or more criteria across multiple ranges. It is an advanced version of COUNTIF, supporting up to 127 range/criteria pairs. The function is used for data analysis tasks, such as counting tasks by date and priority. Syntax: =COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2], …). It…
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…
