ISNONTEXT Function
What is the ISNONTEXT Function? The ISNONTEXT Function is categorized under Excel Information functions. The function helps to check if a cell contains text or not (is anything typed into a cell?). It will return TRUE if the value is text and if not, FALSE. For example, if the given value is a number, date,…
ISNA Function
What is the ISNA Excel Function? The ISNA Excel Function is categorized under Information functions. This function helps in checking if a cell contains the #N/A! error. It will return a FALSE value for other types of errors. As a financial analyst, we deal with data and perform analysis on it. The ISNA function helps…
ISLOGICAL Function
What is the ISLOGICAL Function? The ISLOGICAL Function is categorized underExcel Information functions. The function will test the value or expression provided and return a logical value. That is, it will evaluate the value or expression to provide a TRUE or FALSE result. ISLOGICAL is part of a group of functions called the IS functions,…
ISEVEN Function
What is the ISEVEN Function? The ISEVEN Function is categorized under Excel Information functions. ISEVEN will return TRUE if the number is even or FALSE if the number is not even, or odd. In financial analysis, we need to deal with numbers. The ISEVEN function is useful in data analysis where we need to understand…
STDEVA Function
What is the STDEVA Function? The STDEVA Function is categorized under Excel Statistical functions. It will estimate the standard deviation based on a sample. As a financial analyst, STDEVA can be useful in finding out the rate of return on an investment and measuring the investment’s volatility. If a stock is volatile, it will have a…
MODE.MULT Function
What is the MODE.MULT Function? The MODE.MULT Functionis categorized under Excel Statistical functions. It will return a vertical array of statistical modes within a list of given numbers. The function was introduced in MS Excel 2010 and hence is unavailable in earlier versions. As a financial analyst, MODE.MULT is useful in financial analysis, as it…
MODE.SNGL Function
What is the MODE.SNGL Function? The MODE.SNGL Function is categorized under Excel Statistical functions. It will return the most frequently occurring number in a numeric data set. The function was introduced in MS Excel 2010 and is unavailable in earlier versions. As a financial analyst, MODE.SNGL can be used to find out the most frequently…
POISSON.DIST Function
WHAT is the POISSON.DIST Function? The POISSON.DIST Function is categorized under Excel Statistical functions. It will calculate the Poisson probability mass function. As a financial analyst, POISSON.DIST is useful in forecasting revenue. Also, we can use it to predict the number of events occurring over a specific time, e.g., the number of cars arriving at…
CRITBINOM Function
What is the CRITBINOM Function? The CRITBINOM Function is categorized under Excel Statistical functions. It will return the smallest value that is greater than or equal to the criterion value. The function returns the inverse of the Cumulative Binomial Distribution. That is, for a specific number of independent trials, CRITBITNOM will return the smallest value…
