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…
What is the ERROR.TYPE Function? The ERROR.TYPE Function is categorized as an Excel Information function. The function returns a number that corresponds to a specific error value. If there is no error, it will return #N/A. While doing financial analysis, we can use this to test for a specific error value. Also, we can use…
What is the CHAR Function? The CHAR Function is categorized under Excel Text Functions. It returns a character specified by a number. As a financial analyst, the CHAR function is useful in coding page numbers received from other files into characters, or when we wish to insert a line break into text. Formula =CHAR(number) The…
