by Ilker | May 11, 2021 | Excel Formulas
STOCKHISTORY is a Lookup & Reference function that can retrieve historical data about given financial instrument and spill the results into the workbook. You can populate a stock quote’s daily open, close, volume, high, and low values for the specified periods. In...
by Ilker | Mar 23, 2021 | Excel Formulas
The CHISQ.TEST is a Statistical function that calculates the chi squared (χ2) distribution and returns the probability of a value chi-squared (χ2) between observed and expected data. The chi squared (χ2) test can be used to assess the relationship between two data...
by Ilker | Feb 2, 2021 | Excel Formulas
NORMSINV Excel formula is a Statistical function that calculates the inverse of the standard normal cumulative distribution of a specific probability. The standard normal distribution is a type of normal distribution with a mean of zero (0) and a standard deviation of...
by Ilker | Jan 26, 2021 | Excel Formulas
FREQUENCY is a Statistical function that can calculate how often values occur in a set of data and returns the occurrence counts as a vertical array. These numbers represent frequencies can be helpful for charting histograms. In this guide, we’re going to show you how...
by Ilker | Jan 22, 2021 | Excel Formulas
LAMBDA is a special function that can create custom functions in the scope of a named range. You can essentially create a user defined function without any VBA, macro, or JavaScript knowledge. In this guide, we’re going to show you how to use the LAMBDA function and...
by Ilker | Jan 19, 2021 | Excel Formulas, Uncategorized
The PI function is a Math and Trigonometry formula that returns the equivalent value for the mathematical constant pi (π), which is commonly used in finding the diameter or volume of circles and spherical objects. In this guide, we’re going to show you how to use the...
by Ilker | Jan 18, 2021 | Excel Formulas
The WORKDAY.INTL is a Date & Time function that can add or subtract the number of workdays from a given date. As the name suggests, the function is a modified version of the WORKDAY function which you can incorporate weekends and holidays in your calculations. In...
by Ilker | Jan 15, 2021 | Excel Formulas
WORKDAY is a Date & Time function that can add or subtract the number of workdays from a given date. In this guide, we’re going to show you how to use the WORKDAY function and also go over some tips and error handling methods. Supported versions Excel 2007 and...
by Ilker | Jan 15, 2021 | Excel Formulas
UNICODE is a Text function that returns a corresponding numeric code of a Unicode character. Unicode is a character set, like ASCII. However, it contains characters from different languages, scripts and symbols, including ASCII characters. Each character has its own...