What is the EDATE Function? The EDATE Function is categorized under Excel DATE/TIME Functions. The function helps add a specified number of months to a date and returns the result as a serial date. Apart from helping a financial analyst calculate maturity dates for accounts payable or accounts receivable that fall on the last day…
What is the PERMUTATIONA Function? The PERMUTATIONA Function is an Excel Statistical function. It returns the number of permutations that are possible for a specified number of objects in a given set. Introduced in MS Excel 2013, it’s important to note the function includes repetitions in the number it returns. Formula =PERMUTATIONA(number, number_chosen) The PERMUTATIONA function…
What is the CODE Function? The CODE Function is categorized under Excel Text functions. It returns a numeric code for the first character in a given text string. The returned code corresponds to the character set used by the computer. The Windows operating system uses the ANSI character set, whereas Mac OS uses the Macintosh…
What is the TEXTJOIN Function? The TEXTJOIN Function joins text from two or more strings together with a delimiter separating each value. Introduced in MS Excel 2016, TEXTJOIN is categorized as an Excel String/Text function. Formula =TEXTJOIN(delimiter, ignore_empty, text1, [text2], …text_n) The TEXTJOIN function uses the following arguments: Delimiter (required argument) – The string that…
What is the COMBIN Function? The COMBIN Function is an Excel Math and Trigonometry function. The function will calculate the number of combinations without repetitions for a given number of items. It was introduced in MS Excel 2000. Formula =COMBIN(number, number_chosen) The COMBIN function uses the following arguments: Number (required argument) – The number should either…
What is the NETWORKDAYS.INTL Function? The NETWORKDAYS.INTL Function helps in calculating the number of workdays between two given dates and, thus, works as a business days calculator. It is a built-in function and is categorized as an Excel Date/Time Function. The function was introduced in MS Excel 2010. Formula =NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays]) The NETWORKDAYS.INTL…
What is the AVERAGEIFS Function? The AVERAGEIFS Function is an Excel Statistical function that calculates the average of all numbers in a given range of cells, based on multiple criteria. The function was introduced in Excel 2007. This guide will demonstrate how to calculate the average with multiple criteria in Excel. Formula =AVERAGEIFS(average_range, criteria_range1, criteria1,…
What is the CLEAN Function? The CLEAN Function is categorized under Excel Text functions. The function removes non-printable characters from the given text. As financial analysts, we often import data from various sources and the CLEAN function can help remove nonprintable characters from a supplied text string. It is also useful in removing line breaks….
What is the HLOOKUP Function? HLOOKUP stands for Horizontal Lookup and can be used to retrieve information from a table by searching a row for the matching data and outputting from the corresponding column. While VLOOKUP searches for the value in a column, HLOOKUP searches for the value in a row. Formula =HLOOKUP(value to look…
What is the XOR Function? The XOR Function was introduced in Excel 2013 and is available under Excel Logical functions. It is a logical “exclusive OR” function. For two given logical statements, the XOR function would return TRUE if one of the statements is true and FALSE if both statements are true. If neither of…
