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…
What is a Bull Put Spread? A bull put spread, which is an options strategy, is utilized by an investor when he believes the underlying stock will exhibit a moderate increase in price. A bull put spread involves purchasing an out-of-the-money (OTM) put option and selling an in-the-money (ITM) put option with a higher strike…
What is a Bull Call Spread? A bull call spread, which is an options strategy, is utilized by an investor when he believes a stock will exhibit a moderate increase in price. A bull spread involves purchasing an in-the-money (ITM) call option and selling an out-of-the-money (OTM) call option with a higher strike price but…
What is “Best Efforts”? In a securities offering, “best efforts” refers to a contractual term in which the underwriter promises to do the best it can to sell as much of a securities offering as possible. Understanding “Best Efforts” In a best efforts offering, not all securities are required to be sold. Generally, the underwriter…
The LOOKUP function in Excel retrieves a value from a one-row or one-column range. It performs a rough match lookup either vertically or horizontally. The vector form syntax is =LOOKUP(lookup_value, lookup_vector, [result_vector]), while the array form is =LOOKUP(lookup_value, array). Common applications include comparing rows or columns of data. The function handles simple lookups and returns…
What is the COUNT Function? The COUNT Function is an Excel Statistical function. This function helps count the number of cells that contain a number, as well as the number of arguments that contain numbers. It will also count numbers in any given array. It was introduced in Excel in 2000. As a financial analyst,…
