Formulae Handbook

Causal's complete handbook on Excel and Google Sheets formulae

Excel

ABS

ABS is used in Excel to calculate the absolute value of a number. The absolute value of a number is the distance of the number from zero on the number line.

ACCRINT

The ACCRINT function in Excel calculates the accrued interest for a given investment over a period of time. The function takes three arguments: the investment amount, the interest rate, and the number of periods. The accrued interest is then displayed in a cell.

ACCRINTM

I use ACCRINTM to calculate the accrued interest for a bond or note. I enter the maturity date, the issue date, the face value, the current interest rate, and the number of days since the issue date. ACCRINTM then calculates the accrued interest.

ACOS

ACOS is an Excel function that calculates the arccosine of a number. The function takes a single argument, the number you want to calculate the arccosine of. The arccosine of a number is the inverse cosine of that number.

ACOSH

The A-COSH function in Excel is used to calculate the inverse cosine of a number. To use the function, enter the number you want to calculate the inverse cosine of into the function's argument, and press the Enter key. The inverse cosine of the number will be displayed in the cell.

ACOT

I use ACOT in Excel by inputting the angle, cosine, and tangent values into the corresponding cells and then pressing the "enter" key. This will calculate the arc length for me and give me the answer in the cell adjacent to the input cells.

ACOTH

I use ACOTH in Excel to calculate the inverse of the cumulative distribution function for a given probability. This allows me to find the probability that a given value falls within a given range.

ADDRESS

ADDRESS is a function in Excel that takes a row and column number and returns the value in that cell. For example, if I wanted to find the value in cell A1, I would use the function ADDRESS(1,1).

AGGREGATE

AGGREGATE is used in Excel to summarize data in a range of cells. The function can be used to calculate the sum, average, minimum, or maximum of the values in a range, or to count the number of cells that contain a particular value.

AMORDEGRC

I use the AMORDEGRC function to calculate the depreciation of an asset for a given period of time. The function takes the depreciation expense, the beginning balance of the asset, and the number of periods as input, and calculates the depreciation expense for each period.

AMORLINC

AMORLINC is an acronym for "A Method for Ordering Ranked Lists In Excel." It is a formula that can be used in Excel to help organize and rank data. The formula is relatively simple to use, and can be applied to data that is in a list or table format. The AMORLINC formula can be used to help prioritize items in a list, or to rank items in order of importance.

AND

In Excel, the AND operator is used to test whether two conditions are both true. For example, you could use it to test whether two cells contain the same value.

ARABIC

Arabic is a difficult language to use in Excel. The text formatting is very different from English, and the language has its own set of symbols that are not present on a standard keyboard. However, with a little practice, it is possible to use Arabic in Excel. First, type the text in Arabic in a text editor such as Microsoft Word. Next, copy and paste the text into Excel. Format the text using the Arabic font, and use the symbols that are specific to the Arabic language.

AREAS

There are many ways to use areas in Excel. One way is to use them as a way to organize your data. You can create different areas for different types of data, or for different parts of your data. This can make it easier to find and work with the data that you need. Another way to use areas is to create formulas that will reference data from different areas. This can be a helpful way to keep your data organized and make it easier to update.

ARRAYTOTEXT

ARRAYTOTEXT is a function that returns text from an array of cells. The text is returned in the order that the cells are listed in the array.

ASC

In Excel, you can use the ASC function to return the ASCII code of the first letter of a text string. The ASC function is a built-in function in Excel that is categorized as a String function. The syntax for the ASC function is:=ASC(text)Where "text" is the text string for which you want to return the ASCII code of the first letter.

ASIN

ASIN is used in Excel to determine the Amazon Standard Identification Number for a product. This number can then be used to track the product on Amazon or find information about the product.

ASINH

The Excel ASINH function returns the inverse hyperbolic sine of a number. The function takes as input a single number, and returns the inverse hyperbolic sine of that number.

ATAN

ATAN is a function used in Excel to calculate the angle of a given point on a unit circle. The angle is measured in radians, and can be used to calculate things like the direction a projectile is traveling or the slope of a line.

ATAN2

ATAN2 is used in Excel to calculate the angle between two points. The angle is returned in radians.

ATANH

The ATANH function in Excel calculates the arctangent of a number, using the hyperbolic tangent function. The function takes one argument, the number to be converted to an angle. The angle is returned in radians.

AVEDEV

AVEDEV calculates the average deviation of a set of numbers. To use AVEDEV in Excel, you must first enter the numbers you want to calculate the deviation for into a spreadsheet. Then, in a separate column, enter the formula "=AVEDEV(A1:A10)" where "A1:A10" is the range of cells containing the numbers you want to calculate the deviation for. Excel will then calculate the average deviation for the numbers in that range.

AVERAGE

To calculate the average of a set of numbers in Excel, you can use the AVERAGE function. The AVERAGE function takes a set of numbers as input and calculates the average of those numbers.

AVERAGEA

The AVERAGEA function in Excel takes a list of numbers and calculates the average of the numbers in the list. To use the AVERAGEA function, you need to enter the list of numbers in the function's argument, and then press the Enter key on your keyboard.

AVERAGEIF

I use AVERAGEIF to find the average of a certain range of cells, based on a specific condition. For example, if I want to find the average of all the cells in a column that are greater than 100, I would use the AVERAGEIF function.

AVERAGEIFS

I use AVERAGEIFS in Excel to calculate the average of a range of cells that meet a certain criteria. I can use AVERAGEIFS to average only the cells that are not empty, or only the cells that are greater than or equal to a certain value, or only the cells that are less than or equal to a certain value.

BAHTTEXT

BAHTTEXT is used to convert text to Thai Baht currency. The syntax is =BAHTTEXT(text,currency_symbol). Text is the text to be converted, and currency_symbol is the symbol for Thai Baht, ฿.

BASE

I use BASE in Excel to calculate the basic statistics for a data set. I can calculate the mean, median, mode, and standard deviation with BASE. I can also calculate the variance and the chi-squared statistic.

BESSELI

BESSELI is a function in Excel that calculates the Bessel function of the first kind of an integer argument. To use BESSELI in Excel, you can type "=BESSELI(" into a cell, and then the argument you want to calculate the Bessel function for. For example, if you wanted to calculate the Bessel function for the number 5, you would type "=BESSELI(5)" into a cell.

BESSELJ

The Excel function BESSELJ(x, order) calculates the Bessel function of the first kind, order x.

BESSELK

BESSELK is a function in Excel that calculates the modified Bessel function of the second kind, K. This function is used to calculate the real or imaginary part of the function, depending on the argument.

BESSELY

The BESSELY function in Excel is used to calculate the beta coefficient for a given stock. The beta coefficient is a measure of the volatility of a stock in relation to the market as a whole.

BETA.DIST

BETA.DIST is a Microsoft Excel function that calculates the beta distribution. To use it, you must first enter the parameters for the function. These parameters are the mean, the standard deviation, and the number of degrees of freedom. After you have entered these parameters, you must click the "Enter" button. The function will then calculate the beta distribution for you.

BETA.INV

To use the BETA.INV function in Excel, you first need to open the Excel spreadsheet program. Once you have the program open, you can then begin to input data into the cells of the spreadsheet. In the cell where you want the result of the BETA.INV function to appear, you will need to type in "=BETA.INV(" followed by the parentheses symbol. After the parentheses, you will need to input the values for the function. In the example problem, this would be the number 1.6, the number of degrees of freedom, and the value of the beta coefficient. After you have input all of the values, you will need to press the enter key on your keyboard in order to complete the function.

BETADIST

The BETADIST function in Excel is used to calculate the probability that a given value is less than or equal to a given value. The function takes two arguments: the first is the value you are testing, and the second is the value you are comparing it to. The function then calculates the probability that the given value is less than or equal to the second value.

BETAINV

I use BETAINV in Excel to calculate the inverse of the beta distribution. This is a useful tool for estimating the likelihood of an event happening, based on past data.

BIN2DEC

To convert a binary number to decimal in Excel, you can use the BIN2DEC function. This function takes a binary number as an input, and returns the corresponding decimal value.

BIN2HEX

To convert a binary number to hexadecimal in Excel, you can use the BIN2HEX function. This function takes a binary number as an input and converts it to a hexadecimal string.

BIN2OCT

To convert a binary number to octal in Excel, use the BIN2OCT function. This function takes a binary number as an input and returns the octal equivalent.

BINOM.DIST

The BINOM.DIST function in Excel is used to calculate the probability of a specific event occurring when there are only two possible outcomes. The function takes the number of trials, the probability of success, and the number of failures as inputs. The output is the probability of the event occurring.

BINOM.DIST.RANGE

Binomial distribution is a statistical measure that can be used to calculate the probability of a certain number of successes in a given number of trials. The Binomial.DIST.RANGE function in Excel allows you to calculate the binomial distribution for a range of values, which can be helpful for determining the likelihood of a particular outcome.

BINOM.INV

The Excel BINOM.INV function calculates the probability that a given number of successes will occur in a given number of trials, using the binomial distribution. The function takes four arguments: the number of successes, the number of trials, the probability of success, and the cumulative probability. The function returns a value between 0 and 1, representing the probability that the number of successes will occur.

BINOMDIST

The BINOMDIST function in Excel is used to calculate the probability of success of an event, given that it has a known number of trials and a known probability of success for each trial. The function takes three arguments: the number of trials, the probability of success for each trial, and the number of successes. It then calculates the probability of getting at least that many successes, given the specified probability of success.

BITAND

The BITAND function in Excel takes two arguments and returns the bitwise AND of those two arguments. The function can be used to test whether two bits are equal, or to return the bitwise AND of two numbers.

BITLSHIFT

BITLSHIFT is used in Excel to shift the bits of a number to the left or right. This can be used to change the number of decimal places in a number, or to change the number into a different number format.

BITOR

BITOR is a Boolean function that takes two arguments, and returns TRUE if both arguments are TRUE, and FALSE if either argument is FALSE. In Excel, you can use BITOR to test whether two cells contain the same value. For example, if you want to test whether two cells contain the same value, you can use the following formula:=BITOR(A1,A2)

BITRSHIFT

BITRSHIFT is a function in Excel that allows you to shift bits to the left or right. The function takes two arguments: the number of bits to shift and the number of places to shift them. The function returns the new value of the number after the bits have been shifted.

BITXOR

Bitwise operators work on individual bits in a number, and Excel has a few bitwise operators: AND, OR, XOR, and NOT. To use a bitwise operator in Excel, you put the operator between the two numbers you want to operate on. For example, the bitwise OR operator (represented by the | character) will return a 1 if either of the numbers has a 1 in that position, and a 0 if both numbers have a 0 in that position. The bitwise XOR operator (represented by the ^ character) will return a 1 if the numbers are different, and a 0 if the numbers are the same.

CALL

In Excel, CALL is used to call a function. For example, the function =CALL("MYFUNC",1,2) would call the function MYFUNC with the arguments 1 and 2.

CEILING

CEILING is a mathematical function used in Excel to round a number up to the nearest integer. For example, if you type =CEILING(5.5,1), Excel will return 6.

CEILING.MATH

CEILING.MATH is used to round a number up to the nearest integer. For example, if you enter the number 2.5 into CEILING.MATH, the function will return 3.

CEILING.PRECISE

CEILING.PRECISE rounds a number up to the nearest integer or to the nearest multiple of significance. In Microsoft Excel, you can use the CEILING.PRECISE function to round a number up to the nearest integer or to the nearest multiple of significance.

CELL

CELL in Excel is used to return the address of a cell in a worksheet. The CELL function can be used in a formula to return the address of a cell that contains a value or the address of a cell that is the result of a calculation.

CHAR

CHAR(x) function in Excel returns the character at the xth position in a string.

CHIDIST

The CHIDIST function in Excel is used to calculate the chi-squared statistic for a given set of data. The function takes two input parameters: the first is the data set, and the second is the number of data points in the set. The function then calculates the chi-squared statistic for the data set and returns the result.

CHIINV

The Excel function CHIINV returns the inverse of the chi-squared distribution with degrees of freedom. The function takes one argument, which is the number of degrees of freedom.

CHISQ.DIST

There are a few different ways to use the CHISQ.DIST function in Excel. You can use it to calculate a chi-squared statistic for a given set of data, or you can use it to calculate the probability of a chi-squared statistic occurring given a set of data.

CHISQ.DIST.RT

The CHISQ.DIST.RT function in Excel is used to calculate the probability of a chi-squared distribution. The function takes two arguments: the first is the number of degrees of freedom, and the second is the chi-squared value. The function then returns the probability of the chi-squared distribution.

CHISQ.INV

The CHISQ.INV function in Excel is used to calculate the inverse of the chi-squared distribution. It can be used to calculate the probability of a given value or to find the cutoff value for a given probability.

CHISQ.INV.RT

The Excel function CHISQ.INV.RT is used to calculate the inverse of the chi-squared distribution function. The function takes as input the number of degrees of freedom and the chi-squared value, and returns the inverse of the chi-squared distribution.

CHISQ.TEST

The CHISQ.TEST function in Excel is used to calculate the chi-squared statistic for a given set of data. The function can be used to compare two sets of data or to compare a set of data to a theoretical distribution.

CHITEST

CHITEST is a function in Excel that allows you to compare two lists of data and find the differences between them. You can use it to compare the results of two different tests, for example, or to see which items are different between two lists of data.

CHOOSE

CHOOSE is a function in Excel that allows you to choose a value from a list of values. You can use CHOOSE to return a value for a specific position in a list, or to return a value based on a specific condition.

CLEAN

I use CLEAN to remove all non-printing characters from a text string. This can be useful when cleaning up data or when creating text-based reports.

CODE

In Excel, CODE can be used to return the ASCII code for a character. The ASCII code is a numerical representation of a character that can be used for text manipulation and other purposes.

COLUMN

COLUMN is used to create a column of data in a spreadsheet. The COLUMN function is used to specify the column number in a range of cells.

COLUMNS

COLUMNS is a function in Excel that allows you to return a column number from a given range of cells. This function is especially useful when you need to refer to a specific column in a range of cells, as it can return the column number for you.

COMBIN

The COMBIN function in Excel calculates the number of combinations for a given number of items. The syntax for the function is COMBIN(number_of_items, number_of_items). The function takes two arguments: the number of items in the set and the number of items to choose from. The function returns the number of combinations for the given set.

COMBINA

I use COMBINA in Excel to combine data from two different columns into a single column. I can use this function to combine data from two different tables, or to combine data from two different rows within the same table.

COMPLEX

In Excel, COMPLEX is used to calculate the complex number. The complex number is the combination of a real number and an imaginary number. The real number is the part that is located on the horizontal axis, and the imaginary number is the part that is located on the vertical axis.

CONCAT

The CONCAT function in Excel is used to join two or more text strings into one string. The function takes a maximum of 255 arguments, so it can be used to join a large number of text strings together. The function is often used to combine the values in two or more cells into a single cell, or to combine the text in two or more cells into a single cell.

CONCATENATE

In Excel, the CONCATENATE function is used to join two or more text strings into one string. The function takes a series of text strings as its arguments, and joins them together in the order that they are specified. The resulting string is returned as a single value.

CONFIDENCE

The CONFIDENCE function in Excel is used to calculate the confidence interval for a population mean. The function takes the population mean, the standard deviation, and the sample size as inputs and calculates the lower and upper bounds of the confidence interval.

CONFIDENCE.NORM

I use the CONFIDENCE.NORM function to calculate the probability that a value is within a certain range, given a population mean and standard deviation. This function is useful for estimating confidence intervals.

CONFIDENCE.T

I use CONFIDENCE.T in Excel to calculate the confidence interval for a given population mean. This function allows me to estimate the range of values within which the population mean is likely to fall, given the sample size and the margin of error.

CONVERT

I use CONVERT in Excel to convert between different measurement systems. For example, I might use CONVERT to convert inches to centimeters or to convert gallons to liters. CONVERT is a really useful tool for working with data that uses different measurement systems.

CORREL

CORREL is used in Excel to find the correlation coefficient between two sets of data. The correlation coefficient is a number between -1 and 1 that indicates the strength of the relationship between the two sets of data. A correlation coefficient of 1 indicates a perfect positive relationship, while a correlation coefficient of -1 indicates a perfect negative relationship. A correlation coefficient of 0 indicates no relationship between the two sets of data.

COS

COS is used in Excel to calculate the cosine of a given angle. The COS function takes an angle in radians as its input, and returns the cosine of that angle.

COSH

COSH is an Excel function that calculates the cost of a standard option. The syntax is COSH(strike price, time to expiration, implied volatility).

COT

In Excel, COT stands for "cost of the trade." This calculation is used to measure the profitability of a position by subtracting the cost of the trade from the current market value of the position. This calculation is often used to compare the profitability of different positions.

COTH

The COTH function in Excel is used to calculate the annual interest rate on a loan or investment. To use the function, input the loan amount, the number of payments, and the interest rate. The COTH function will then calculate the annual interest rate.

COUNT

I use COUNT in Excel to count the number of cells that contain numbers.

COUNTA

COUNTA is a function in Excel that counts the number of cells in a range that contain a value. This function is useful for counting the number of items in a column or row, or for counting the number of cells that are not blank.

COUNTBLANK

COUNTBLANK is a function in Excel that counts the number of blank cells in a given range of cells. This can be useful for identifying cells that are empty or have text in them.

COUNTIF

The COUNTIF function in Excel allows you to count the number of cells in a range that meet a certain criteria. For example, you could use COUNTIF to count the number of cells in a range that are greater than 100.

COUNTIFS

COUNTIFS is a function in Excel that allows you to count the number of cells in a range that meet a certain criteria. For example, you could use COUNTIFS to count the number of cells in a range that are greater than 100.

COUPDAYBS

COUPDAYBS calculates the number of days from the beginning of the coupon period to the date. The function takes into account the number of days in each month and whether the month is a leap year.

COUPDAYS

To calculate the number of days between two dates, use the COUPDAYS function in Excel. This function will return the number of days between the two dates, including both dates.

COUPDAYSNC

I use COUPDAYSNC in Excel to calculate the number of days until the next coupon payment on a bond. This is useful for estimating the bond's yield-to-maturity.

COUPNCD

I use COUPNCD as a function in Excel to compare two dates and determine the number of days between them. The function takes two input arguments: the first is the date to be compared, and the second is the date from which the number of days should be counted.

COUPNUM

The COUPNUM function in Excel returns the number of coupons in a given range. The function takes two arguments: the first is the range of cells containing the coupon codes, and the second is the cell in which you want the function to return the number of coupons.

COUPPCD

I use COUPPCD in Excel to calculate the percentage of a coupon that has been used. I enter the value of the coupon in cell A1, and the value of the coupon after it has been used in cell A2. I then use the formula "=COUPPCD(A1,A2)" in cell A3 to calculate the percentage of the coupon that has been used.

COVAR

Covariance is a statistic that is used to measure how two sets of data are related. It is used to find out how much variation there is in one set of data when you know the value of another set of data. You can use covariance in Excel by using the cov function.

COVARIANCE.P

Covariance.P is a function in Excel that calculates the population covariance of two sets of data. The function takes two arrays of data as input, and calculates the covariance between the two arrays. The function is useful for comparing two sets of data to see if they are correlated.

COVARIANCE.S

I use COVARIANCE.S in Excel to measure the strength of the linear relationship between two sets of data. It returns a value that tells me how likely it is that changes in one set of data are associated with changes in the other set. This can be helpful for making decisions about investing or other business decisions.

CRITBINOM

The CRITBINOM function is used in Excel to calculate the probability of a particular event occurring, given that it has already occurred a certain number of times. For example, if you wanted to know the probability of rolling a six on a six-sided die, you could use the CRITBINOM function to calculate it.

CSC

I use CSC in Excel to center text in a cell. I select the cell I want to center the text in, type the text I want to center, and then use CSC to center it.

CSCH

I use CSCH in Excel to calculate the accrued interest on a bond. I enter the bond's par value, the number of days to maturity, and the annual interest rate, and then use the CSCH function to calculate the accrued interest.

CUBEKPIMEMBER

I use CUBEKPIMEMBER to create a PivotTable from a data set that has been filtered by a particular member. I can then use the PivotTable to analyze the data set by that member.

CUBEMEMBER

CUBEMEMBER is used to return information about a specific member in a cube. The function takes the name of the member and the cube as its arguments. It then returns the value of the member in the cube.

Google Sheets

ABS

ABS stands for "absolute value." The ABS function takes a number and returns the absolute value of that number. For example, if you enter the number -5 into the ABS function, it will return 5.

ACCRINT

ACCOUNT is a function in Google Sheets that calculates the accrued interest on a loan or investment over a given period of time. The function takes three parameters- the initial investment, the periodic interest rate, and the number of periods. For example, if you invest $1,000 at a 5% interest rate, compounded monthly, over a period of 5 years, the ACCOUNT function would return $521.06, which is the amount of accrued interest.

ACCRINTM

The ACCRINTM function in Google Sheets calculates the accrued interest for a given investment over a given period of time. To use the function, you must first input the initial investment amount, the interest rate, and the number of periods. The function will then calculate the accrued interest for you and return the result. This can be helpful for budgeting and forecasting future expenses.

ACOS

The ACOS function in Google Sheets returns the arc cosine of a number. This function can be used to calculate the cosine of an angle, or to find the angle whose cosine is a given value.

ACOSH

The ACOSH() function in Google Sheets calculates the inverse hyperbolic cosine of a number. To use the function, enter the number you want to calculate the inverse hyperbolic cosine of in the cell where you want the result to appear, and then enter the function name and parentheses, like this: =ACOSH(number).

ACOT

I use ACOT in Google Sheets to calculate the area of a triangle. I enter the base, height, and angle of the triangle into the appropriate cells, and then the spreadsheet calculates the triangle's area. This is a handy tool for geometry homework!

ACOTH

In order to use ACOTH in Google Sheets, you must first install the add-on. To do this, open Google Sheets and click on the menu in the top left corner. Next, select "Add-ons" and then "Get add-ons". Finally, search for "ACOTH" and install the add-on. Once the add-on is installed, you can open it by clicking on the menu in the top left corner and selecting "ACOTH".

ADD

In Google Sheets, you can use the ADD function to add two or more numbers together. For example, if you want to add the numbers 1 and 2, you would type =ADD(1,2) into a cell. This would return the result 3.

ADDRESS

ADDRESS in Google Sheets can be used to return the coordinates of a cell in a given row and column. It can also be used to return the address of a range of cells.

AMORLINC

I use AMORLINC in Google Sheets to find the average monthly return of a stock over a given number of months. I enter the stock symbol, the number of months, and click "Get AMORLINC." The results show the average monthly return for the stock over the given number of months.

AND

Google Sheets uses the AND operator to return a TRUE or FALSE result. The formula =AND(A1>5,A2<10) would return TRUE if A1 is greater than 5 and A2 is less than 10.

ARABIC

In order to use Arabic in Google Sheets, you must first enable the Arabic language setting. Once you have enabled Arabic, you can type in Arabic by using the right-to-left keyboard layout. You can also use the Arabic input menu to type in Arabic.

ARABIC

In order to use Arabic in Google Sheets, you must first enable the Arabic language setting. Once you have enabled Arabic, you can type in Arabic by using the right-to-left keyboard layout. You can also use the Arabic input menu to type in Arabic.

ARRAYFORMULA

In Google Sheets, ArrayFormula is used to create and populate arrays. An array is a collection of data that is organized into a single unit. The data can be of any type, including text, numbers, or boolean values. Arrays can be either one-dimensional or multi-dimensional. To create an array in Google Sheets, use the ArrayFormula function. The function takes two arguments: the first is the name of the array, and the second is the data to be stored in the array. To populate an array, use the ArrayFormula function to create the array, and then use the append operator (+) to add new data to the array.

ARRAY_CONSTRAIN

The ARRAY_CONSTRAIN function in Google Sheets allows you to constrain the size of an array. You can use it to specify the maximum number of array elements, or to specify a minimum and maximum size for the array.

ASC

ASC is a built-in function in Google Sheets that allows you to find the ASCII code of a letter or number. To use ASC, simply enter the letter or number you want to find the ASCII code for into the function's brackets, and hit enter. The ASCII code for the letter or number will appear in the cell you're working in.

ASC

ASC is a built-in function in Google Sheets that allows you to find the ASCII code of a letter or number. To use ASC, simply enter the letter or number you want to find the ASCII code for into the function's brackets, and hit enter. The ASCII code for the letter or number will appear in the cell you're working in.

ASIN

ASIN stands for Amazon Standard Identification Number. It is a unique identifier for products sold on Amazon. You can use the ASIN in Google Sheets to get product information from Amazon.

ASINH

ASINH stands for the arcsine of the inverse hyperbolic sine. It is a function used to calculate the inverse hyperbolic sine of a number. In Google Sheets, the ASINH function can be used to calculate the inverse hyperbolic sine of a number in a cell.

ATAN

The ATAN function in Google Sheets is used to calculate the angle of a given set of coordinates. The function takes two input parameters: the X coordinate and the Y coordinate. It then calculates the angle between those two points. The angle is returned as a radian value.

ATAN2

I use the ATAN2 function in Google Sheets to calculate the angle between two points. I can use this function to calculate the angle between two points on a map, or to find the heading of a ship or airplane.

ATANH

I use ATANH in Google Sheets to calculate the arcsine of a number. This is useful for determining the angle of a given point on a unit circle.

AVEDEV

AVEDEV is a function in Google Sheets that calculates the average of the absolute deviation of a set of numbers from the mean. This function is especially useful for determining the variability of a data set. To use AVEDEV in Google Sheets, simply enter the function name followed by the range of cells that you would like to calculate the average of the absolute deviation for.

AVERAGE

In Google Sheets, you can use the AVERAGE function to calculate the average of a set of numbers. To use the function, you first need to enter the numbers you want to average into a spreadsheet, and then select the AVERAGE function from the menu. The function will then calculate the average of the numbers you entered.

AVERAGE.WEIGHTED

In order to use AVERAGE.WEIGHTED in Google Sheets, you need to have a spreadsheet with at least two columns of data. The first column should contain the names of the items you're averaging, and the second column should contain the corresponding weights. Once you have your data set up, you can use the AVERAGE.WEIGHTED function to calculate the weighted average of the items in your spreadsheet.

AVERAGEA

I use AVERAGEA in Google Sheets to calculate the average of a series of numbers. I can enter a list of numbers into a spreadsheet cell, and then use the AVERAGEA function to calculate the average of that list.

AVERAGEIF

To use the AVERAGEIF function in Google Sheets, you first need to enter the data you want to average into a spreadsheet. Then, select the cells you want to average, and type "=AVERAGEIF(range, criteria)" into the cell where you want the average to appear. For example, if you want to average the cells in the range A1:A10, and the cells in that range are only if they are greater than or equal to 50, you would type "=AVERAGEIF(A1:A10, ">=50")" into the cell where you want the average to appear.

AVERAGEIFS

The AVERAGEIFS function in Google Sheets can be used to average a range of cells based on a specific condition. The function takes the following format: AVERAGEIFS(range, criteria, average_range) The range parameter is the array of cells to be averaged. The criteria parameter is the condition to be met in order for a cell to be averaged. The average_range parameter is the range of cells to use as the average if the condition is met.

BASE

In Google Sheets, BASE is used as a built-in function to calculate the logarithm of a number to the BASE you specify.

BETA.DIST

The BETA.DIST function in Google Sheets is used to calculate the beta distribution for a given set of data. The function takes three parameters: the first is the minimum value, the second is the maximum value, and the third is the number of data points. The function then calculates the beta distribution for the given data set and returns the value.

BETA.INV

Beta.Inv is a function in Google Sheets that calculates the inverse of the beta function. The syntax for using this function is Beta.Inv(x,a,b), where x is the value for which you want to calculate the inverse of the beta function, a is the value of the first parameter, and b is the value of the second parameter.

BETADIST

BETADIST is a function in Google Sheets that calculates the beta distribution. To use it, you first need to enter the parameters for the distribution. These include the mean, the standard deviation, and the number of tails. You can then use the function to calculate the probability of a particular event occurring.

BETAINV

In Google Sheets, BETAINV is used to calculate the inverse of the beta distribution. To use BETAINV, you first need to enter the beta distribution parameters. These parameters include the beta level, the degrees of freedom, and the lower and upper bounds. Once you have entered the parameters, you can use BETAINV to calculate the inverse of the beta distribution.

BIN2DEC

To use BIN2DEC in Google Sheets, you first need to enter the equation into a cell. Then, select the cell and press "Ctrl+Shift+Enter" on your keyboard. This will automatically enter the equation into the cell and format it correctly.

BIN2HEX

Bin2Hex is a handy tool that helps you convert binary data to hexadecimal data in Google Sheets. To use it, simply enter the binary data into the first column, and the hexadecimal data will be generated in the second column. This can be useful when you need to store binary data in a spreadsheet or when you need to convert data from one format to another.

BIN2OCT

The BIN2OCT function in Google Sheets takes a binary number and converts it to an octal number. To use the function, type "=BIN2OCT(number)" into a cell, where "number" is the binary number you want to convert. The function will return the octal equivalent of the binary number.

BINOM.DIST

BINOM.DIST is used to calculate the probability of a binomial distribution. In Google Sheets, you can use the function by typing =BINOM.DIST(number of trials, probability of success, number of successes) into a cell.

BINOM.DIST

To use BINOM.DIST in Google Sheets, you first need to enter the number of trials, the probability of success, and the number of successes. You can then use the function to calculate the probability of at least one success or the number of trials necessary for a specific number of successes.

BINOM.DIST

BINOM.DIST is used to calculate the probability of a binomial distribution. In Google Sheets, you can use the function by typing =BINOM.DIST(number of trials, probability of success, number of successes) into a cell.

BINOM.INV

The BINOM.INV() function in Google Sheets calculates the binomial coefficient, which is the number of unique combinations of n items, taken r at a time. This function can be used to calculate probabilities and odds, as well as to generate permutations and combinations. To use the BINOM.INV() function, enter the following into a cell: =BINOM.INV(n,r,p)

BINOM.INV

The BINOM.INV function in Google Sheets is used to calculate the probability of a specific event occurring in a binomial distribution. The function takes two inputs - the number of trials and the probability of success - and calculates the probability of the event occurring at least once.

BINOM.INV

The BINOM.INV() function in Google Sheets calculates the binomial coefficient, which is the number of unique combinations of n items, taken r at a time. This function can be used to calculate probabilities and odds, as well as to generate permutations and combinations. To use the BINOM.INV() function, enter the following into a cell: =BINOM.INV(n,r,p)

BINOMDIST

The BINOMDIST function in Google Sheets calculates the probability of getting a certain number of successes in a set number of trials. To use the function, you need to input the number of successes, the number of trials, and the probability of success for each trial. The function will then calculate the probability of getting the desired number of successes.

BINOMDIST

The BINOMDIST function in Google Sheets calculates the probability of getting a certain number of successes in a set number of trials. To use the function, you need to input the number of successes, the number of trials, and the probability of success for each trial. The function will then calculate the probability of getting the desired number of successes.

BITAND

BITAND is a Google Sheets function that returns the bitwise AND of two numbers. The function takes two arguments: the first argument is the number to be bitwise-ANDed, and the second argument is the number of bits to be used in the operation.

BITLSHIFT

BITLSHIFT is a mathematical operator that can be used in Google Sheets to shift the bits of a number to the left or right. The BITLSHIFT operator can be used to change the value of a number by a specified number of bits. For example, the BITLSHIFT operator can be used to change the value of a number from 10 to 11 by shifting the bits of the number to the left by 1.

BITOR

BITOR is a logical operator used in Google Sheets that returns true if either of its two arguments is true. It is written as "BITOR(A,B)".

BITRSHIFT

BITRSHIFT is a Google Sheets function that shifts the bits of a number to the left or right. The function takes two arguments: the number to be shifted and the number of bits to shift. The number of bits to shift can be either positive or negative. If the number of bits to shift is positive, the bits will be shifted to the left. If the number of bits to shift is negative, the bits will be shifted to the right.

BITXOR

The BITXOR function in Google Sheets is used to calculate the bitwise exclusive OR of two numbers. The function takes two arguments, the first of which is the first number to be bitwise exclusive OR'ed, and the second of which is the second number to be bitwise exclusive OR'ed. The function returns the bitwise exclusive OR of the two numbers as a decimal value.

CEILING

CEILING Rounds a number up to the nearest integer. CEILING(number, significance)

CEILING.MATH

CEILING.MATH is used to round a number up to the nearest integer. For example, if you have the number 9.3 and you use CEILING.MATH, the result will be 10.

CEILING.PRECISE

CEILING.PRECISE is used to round a number up to the nearest integer. For example, the value 8.5 would be rounded to 9, and the value 3.4 would be rounded to 3.

CELL

CELL is a function in Google Sheets that allows you to return the value of a specific cell in a spreadsheet. You can use CELL to get the value of a cell, the row number of a cell, or the column number of a cell.

CHAR

CHAR(x) in Google Sheets returns the character at position x in the string.

CHAR

CHAR(x) in Google Sheets returns the character at position x in the string.

CHIDIST

To use CHIDIST in Google Sheets, you first need to install the CHIDIST add-on. Once the add-on is installed, you can use it by selecting the "CHIDIST" function from the "Statistical" menu.

CHIDIST

To use CHIDIST in Google Sheets, you first need to install the CHIDIST add-on. Once the add-on is installed, you can use it by selecting the "CHIDIST" function from the "Statistical" menu.

CHIINV

The CHIINV function is used to calculate the inverse of the chi-squared distribution. This function can be used in Google Sheets to calculate the p-value for a chi-squared test.

CHIINV

The CHIINV function is used to calculate the inverse of the chi-squared distribution. This function can be used in Google Sheets to calculate the p-value for a chi-squared test.

CHISQ.DIST

I use the CHISQ.DIST function in Google Sheets to calculate the chi-squared distribution for a given set of data. This function can be used to determine the probability of a given event occurring, based on the chi-squared distribution.

CHISQ.DIST

I use the CHISQ.DIST function in Google Sheets to calculate the chi-squared distribution for a given set of data. This function can be used to determine the probability of a given event occurring, based on the chi-squared distribution.

CHISQ.DIST.RT

The chi-squared distribution is a probability distribution that is used to calculate the probability of obtaining a certain value or range of values for a chi-squared statistic. The chi-squared distribution is used in Google Sheets to determine the probability of obtaining a certain value or range of values for a chi-squared statistic.

CHISQ.DIST.RT

The chi-squared distribution is a probability distribution that is used to calculate the probability of obtaining a certain value or range of values for a chi-squared statistic. The chi-squared distribution is used in Google Sheets to determine the probability of obtaining a certain value or range of values for a chi-squared statistic.

CHISQ.INV

The CHISQ.INV function in Google Sheets can be used to calculate the p-value of a chi-squared statistic. The function takes two input parameters: the chi-squared statistic and the degrees of freedom. The p-value is returned as a decimal value.

CHISQ.INV

The CHISQ.INV function in Google Sheets can be used to calculate the p-value of a chi-squared statistic. The function takes two input parameters: the chi-squared statistic and the degrees of freedom. The p-value is returned as a decimal value.

CHISQ.INV.RT

The CHISQ.INV.RT function in Google Sheets is used to calculate the inverse of the chi-squared distribution function. The function takes two parameters: the number of degrees of freedom, and the chi-squared value. The inverse of the chi-squared distribution function can be used to calculate the probability of a particular chi-squared value occurring, given a certain number of degrees of freedom.

CHISQ.INV.RT

The CHISQ.INV.RT function in Google Sheets is used to calculate the inverse of the chi-squared distribution function. The function takes two parameters: the number of degrees of freedom, and the chi-squared value. The inverse of the chi-squared distribution function can be used to calculate the probability of a particular chi-squared value occurring, given a certain number of degrees of freedom.

CHISQ.TEST

The CHISQ.TEST function in Google Sheets can be used to calculate the chi-squared statistic for a given set of data. The function takes two input arguments: the data set and the number of degrees of freedom. The function returns the chi-squared statistic, the p-value, and the degrees of freedom.

CHISQ.TEST

The CHISQ.TEST function in Google Sheets can be used to calculate the chi-squared statistic for a given set of data. The function takes two input arguments: the data set and the number of degrees of freedom. The function returns the chi-squared statistic, the p-value, and the degrees of freedom.

CHITEST

To use the chi-squared statistic in Google Sheets, you first need to install the Google Sheets Add-on called "CHITEST". After you have installed the Add-on, you can use it by selecting "CHITEST" from the "STATISTICS" menu in Google Sheets.

CHITEST

To use the chi-squared statistic in Google Sheets, you first need to install the Google Sheets Add-on called "CHITEST". After you have installed the Add-on, you can use it by selecting "CHITEST" from the "STATISTICS" menu in Google Sheets.

CHOOSE

CHOOSE is a function in Google Sheets that allows you to select a value from a list of choices. To use CHOOSE, you first need to create a list of values. Then, use the CHOOSE function to select a value from the list. For example, if you have a list of colors called "colors", you can use CHOOSE to select a color from the list. The following formula would return the color "red":=CHOOSE(colors, "red")

CLEAN

CLEAN is a function in Google Sheets that removes all non-printable characters from a text string. This can be useful for cleaning up data that has been entered into a spreadsheet. For example, if you have a column of text data that contains some non-printable characters, you can use the CLEAN function to remove them and make the data easier to read.

CLEAN

CLEAN is a function in Google Sheets that removes all non-printable characters from a text string. This can be useful for cleaning up data that has been entered into a spreadsheet. For example, if you have a column of text data that contains some non-printable characters, you can use the CLEAN function to remove them and make the data easier to read.

CODE

I use CODE in Google Sheets to write equations and functions. This allows me to perform calculations and manipulate data in my spreadsheets.

CODE

I use CODE in Google Sheets to write equations and functions. This allows me to perform calculations and manipulate data in my spreadsheets.

COLUMN

I use COLUMN in Google Sheets to organize my data. I can create a column for each piece of data I want to track, and then put the data in each column. This makes it easy to track and analyze my data.

COLUMNS

COLUMNS in Google Sheets can be used to sort data in a table. You can also use them to create headings for your table. To use COLUMNS in Google Sheets, first select the cells that you want to sort. Then go to the "Data" tab and select "Sort." In the "Sort by" drop down menu, select "COLUMNS." You can then choose the column that you want to sort by.

COMBIN

I use COMBIN in Google Sheets to calculate the number of possible combinations for a set of items. For example, if I have a list of six items, I can use COMBIN to calculate the number of possible combinations of those items.

COMBINA

To use the COMBINA function in Google Sheets, you first need to open a spreadsheet and then select the cell in which you would like the result to appear. Next, type in the following formula: =COMBINA(number1, number2) and then press Enter. Finally, replace "number1" and "number2" with the numbers you would like to use in the function.

COMPLEX

Complex numbers are entered into Google Sheets as a string of the form "a + bi", where a is the real part and bi is the imaginary part. To enter the number -2 + 3i, for example, you would type "-2" in the real part column and "3i" in the imaginary part column. Once the complex number is entered, you can use standard spreadsheet functions on it just as you would any other number. For example, the SUM function can be used to add two complex numbers together.

CONCAT

To use CONCAT in Google Sheets, you first need to select the cells that you want to concatenate. Then, under the "Formulas" tab, select "Concatenate" and select the cells that you want to concatenate.

CONCATENATE

In Google Sheets, the CONCATENATE function is used to join two or more strings of text together into one string. The function is entered into a cell, and the text strings to be joined are separated by commas.

CONCATENATE

In Google Sheets, the CONCATENATE function is used to join two or more strings of text together into one string. The function is entered into a cell, and the text strings to be joined are separated by commas.

CONFIDENCE

I use CONFIDENCE to calculate the probability that a particular value is within a given range. This can be helpful for determining confidence intervals or determining the likelihood of achieving a goal.

CONFIDENCE

I use CONFIDENCE to calculate the probability that a particular value is within a given range. This can be helpful for determining confidence intervals or determining the likelihood of achieving a goal.

CONFIDENCE.NORM

The CONFIDENCE.NORM function in Google Sheets is used to calculate the standard normal distribution for a given set of data. The function takes in an input of two parameters: the first is the number of observations in the dataset, and the second is the standard deviation of the dataset. The function then calculates the z-score for each observation in the dataset, and returns the standard normal distribution for the given set of data.

CONFIDENCE.NORM

The CONFIDENCE.NORM function in Google Sheets is used to calculate the standard normal distribution for a given set of data. The function takes in an input of two parameters: the first is the number of observations in the dataset, and the second is the standard deviation of the dataset. The function then calculates the z-score for each observation in the dataset, and returns the standard normal distribution for the given set of data.

CONFIDENCE.T

CONFIDENCE.T is a function in Google Sheets that calculates the confidence interval for a given set of data. To use it, you first need to enter the data into a spreadsheet, then use the function to calculate the interval. The function takes three arguments: the first is the lower bound of the interval, the second is the upper bound of the interval, and the third is the number of data points in the set.

CONFIDENCE.T

CONFIDENCE.T is a function in Google Sheets that calculates the confidence interval for a given set of data. To use it, you first need to enter the data into a spreadsheet, then use the function to calculate the interval. The function takes three arguments: the first is the lower bound of the interval, the second is the upper bound of the interval, and the third is the number of data points in the set.

CONVERT

The CONVERT function in Google Sheets can be used to convert between different units of measurement. You can use it to convert between imperial and metric measurements, or to convert between different units within a given system of measurement.

CORREL

CORREL is used in Google Sheets to find the correlation between two sets of data. The correlation coefficient is a number between -1 and 1 that indicates the strength of the relationship between the two sets of data. A correlation of 0 means that there is no relationship between the two sets of data, while a correlation of 1 means that the two sets of data are perfectly correlated.

CORREL

CORREL is used in Google Sheets to find the correlation between two sets of data. The correlation coefficient is a number between -1 and 1 that indicates the strength of the relationship between the two sets of data. A correlation of 0 means that there is no relationship between the two sets of data, while a correlation of 1 means that the two sets of data are perfectly correlated.

COS

COS is a function in Google Sheets that calculates the cosine of the given angle. This function can be used to calculate the angle of a triangle, or to find the cosine value for a given angle.

COSH

COSH is used to calculate the cost of an employee's health insurance. To use it, you would first enter the cost of the health insurance premium per month. Then, you would enter the number of employees who are covered by the health insurance plan. COSH will automatically calculate the cost of the health insurance premium per employee.

COT

In Google Sheets, COT can be used to find the cost of a given number of shares over a given period of time. This function can be used to help investors calculate their potential profits and losses.

COTH

COTH is an acronym for "cost of living." It is a measure of the amount of money needed to maintain a certain standard of living. COTH can be used to compare the cost of living in different cities or to determine how much money you need to live comfortably. COTH can be calculated using the cost of living index (COLI) for a given city. The COLI is a measure of the average cost of goods and services in a city.

COUNT

COUNT is a function used to count the number of cells in a given range that contain numbers. To use COUNT in Google Sheets, you must first enter the range of cells you want to count. After you have entered the range, click on the "COUNT" function in the "FUNCTIONS" tab and enter the range you want to count in the "ENTER A RANGE" field. After you have entered the range, click "OK" and the number of cells in the range that contain numbers will be displayed in the "RESULT" field.

COUNT

COUNT is a function used to count the number of cells in a given range that contain numbers. To use COUNT in Google Sheets, you must first enter the range of cells you want to count. After you have entered the range, click on the "COUNT" function in the "FUNCTIONS" tab and enter the range you want to count in the "ENTER A RANGE" field. After you have entered the range, click "OK" and the number of cells in the range that contain numbers will be displayed in the "RESULT" field.

COUNTA

COUNTA is a function in Google Sheets that counts the number of cells in a range that contain a value. To use COUNTA, select the range of cells you want to count, and then use the COUNTA function in the formula bar.

Get started today with Causal

Sign up and get started for free, or book a demo to learn how Causal can transform your finance function.