Excel SLN Function

Excel SLN Function

The SLN function is a Finance function that calculates the depreciation of an asset on a straight-line basis for one period. In this guide, we’re going to show you how to use the SLN function and go over some tips and error handling methods. Supported versions All...
Function: QUOTIENT

Function: QUOTIENT

QUOTIENT is a Math and Trigonometry function which calculates and returns the integer portion of a division. This function can be especially useful for when you want to discard the remainder of a division, and not any of the values. In this guide, we’re going to show...
Function: VARPA

Function: VARPA

The VARPA function is a statistical function that can calculate and return the variance of a population by evaluating text and logical values. Variance provides a general idea of how much data points are spread in a data set, and can be used to calculate the standard...
Function: VARA

Function: VARA

The VARA function is a statistical function that can calculate and return the variance of a sample by evaluating text and logical values. Variance provides a general idea of how much data points are spread in a data set, and can be used to calculate the standard...
Function: VARP

Function: VARP

The VARP function is a statistical function calculates and returns the variance of a population. Variance provides a general idea of how much data points are spread in a data set, and can be used to calculate the standard deviation or determine the risk of an...
Function: VAR.P

Function: VAR.P

The VAR.P function is a statistical function that can calculate and return the variance of a population. This formula was essentially introduced as a replacement for the outdated VARP function. Variance provides a general idea of how much data points are spread in a...

Function: VAR.S

The VAR.S function is a statistical function calculates and returns the variance of a sample. It is also a replacement for the outdated VAR function. The variance provides a general idea of the spread of data, and can be used to calculate the standard deviation or...
Function: STOCKHISTORY

Function: STOCKHISTORY

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...
Function: CHISQ.TEST

Function: CHISQ.TEST

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...