List of functions in Google Sheet

List of functions in Google Sheet. Google Sheet is a sheet of Google made to help you use Excel online. Like Excel, Google Sheet can also create different functions for statistical calculations.

Google Sheet is a sheet of Google made with the purpose to help you use "Excel online". Like Excel, Google Sheet can also create different functions for statistical calculations. In this article, TipsMake.com will list the function lists included in Google Sheet.

The list of functions below will be listed by us based on the type of function used.

1. Database function

DAVERAGE function

DAVERAGE (database_data; field; criteria)

Returns the average value of a selected set of values ​​from an array or database table-like range by using SQL-like queries.

DCOUNT function

DCOUNT (database_data; field; criteria)

Counts numeric values ​​selected from an array or range similar to a database table using SQL-like queries.

DCOUNTA function

DCOUNTA (database_data, school, criteria)

Counts values, including text, selected from an array or range like a database table using SQL-like queries.

DGET function

DGET (database_data; field; criteria)

Returns a unique value from an array or range similar to a database table using SQL-like queries.

DMAX function

DMAX (data base; field; criteria)

Returns the selected maximum value from an array or database table-like range by using SQL-like queries.

DMIN function

DMIN (database_data; school; criteria)

Returns the smallest value selected from an array or range similar to a database table using SQL-like queries.

DPRODUCT function

DPRODUCT (data base; school; criteria)

Returns the product of selected values ​​from an array or range similar to a database table using SQL-like queries.

DSTDEV function

DSTDEV (database_data; field; criteria)

Returns the standard deviation of a population sample selected from an array or range similar to a database table using SQL-like queries.

DSUM function

DSUM (facilities_data, schools, criteria)

Returns the sum of selected values ​​from an array or range similar to a database table using SQL-like queries.

DVARP function

DVARP (facilities_data; schools; criteria)

Returns the variance of the entire selected population from an array or range similar to a database table using SQL-like queries.

2. Google function

ARRAYFORMULA function

ARRAYFORMULA (formula_range)

Enables displaying values ​​returned from an array formula into multiple rows and / or columns and using non-array functions with arrays

DETECTLANGUAGE function

DETECTLANGUAGE (text_or_range)

Specifies the language used in the text within a specified range of cells.

GOOGLEFINANCE function

GOOGLEFINANCE (certificate_key; [attributes]; [start_date]; [end_date | num_dates]; [approximately])

Fetching current or historical securities information from Google Finance.

GOOGLETRANSLATE function

GOOGLETRANSLATE (text; [source language]; [target language])

Translate text from one language to another

IMAGE function

IMAGE (url; [mode]; [height]; [width])

Insert image into cell.

QUERY function

QUERY (data; query; [title])

Run a query in the Google Visualization API Query Language on a variety of data.

SPARKLINE function

SPARKLINE (data; [optional])

Create small charts in a cell.

3. Logic function

IFS

IFS (condition1; value1; [condition2; value2]; .)

Evaluates multiple conditions and returns a value corresponding to the first true condition.

AND FUNCTION

AND (expression_logic1, [expression_logic2, .])

Returns true if all of the provided arguments are logically true, and returns false if any of the provided arguments are logically false.

FALSE function

FALSE ()

Returns the logical value `FALSE`.

IF function

IF (log_logic, value_if_true, value_if_)

Returns a value if a logical expression is `TRUE` and another value if the logical expression is` FALSE`.

IFERROR function

IFERROR function (value, [value_if_error])

Returns the first argument if it is not an error value, otherwise returns the second argument if this argument is present or left blank if this argument is absent.

IFNA function

IFNA (value; value_if_error)

Evaluate a value. If the value is an # N / A error, the function will return the specified value. .

FUNNY NOT

NOT (expression_logic)

Returns the opposite of the logical value - `NOT (TRUE)` returns `FALSE`; `NOT (FALSE)` returns `TRUE`.

OR function

OR (expression_logic1, [expression_logic2, .])

Returns true if any of the provided arguments are logically true, and returns false if all of the provided arguments are logically false.

TRUE function

TRUE ()

Returns the logical value `TRUE`.

XOR function

XOR (expression_logic1; [expression_logic2; .])

The XOR function executes the privilege or of 2 arguments to return 1 if the arguments are different and returns 0 otherwise. .

4. Statistical functions

AVERAGE.WEIGHTED

AVERAGE.WEIGHTED (value; weight; [value added]; [value_sung])

Find the weighted average of a set of values ​​when knowing the corresponding values ​​and weights. .

CHISQ.DIST

CHISQ.DIST (x; degrees_freedom; cumulative)

Calculates the left chi square distribution function, often used in hypothesis testing.

MAXIFS

MAXIFS (range; criteria_range1; criteria1; [criteria_range2; criterion2; .])

Returns the maximum value in a range filtered by a group of criteria.

AVEDEV function

AVEDEV (value1; [value2; .])

Calculate the average of the magnitudes of data deviations from the midpoint of a dataset.

AVERAGE function

AVERAGE (value_1; [value_2; .])

Returns the arithmetic mean value in a dataset, ignoring text.

AVERAGEA function

AVERAGEA (value1; [value2, .])

Returns the arithmetic mean value in a dataset.

AVERAGEIF function

AVERAGEIF (criteria_range; criteria; [average_range])

Returns the average value of a range based on multiple criteria.

AVERAGEIFS function

AVERAGEIFS (midrange_range; criteria_range1; criterion1; [criteria_range2; criterion2; .])

Returns the average value of a range based on multiple criteria.

BETA.DIST

BETA.DIST (value; alpha; beta; cumulative; lower_; upper_value)

Returns the probability of a given value as determined by the beta distribution function. .

BETA.INV function

BETA.INV (probability; alpha; beta; lower_value; upper_limit)

Returns the inverse value of the beta distribution function for a given probability.

CHIINV function

CHIINV (probability; degrees_freedom)

Calculate the inverse of the right chi square distribution function.

CONFIDENCE.NORM function

CONFIDENCE.NORM (alpha; standard_value; compound_size)

Calculate the width of half confidence interval for a standard distribution function. .

CONFIDENCE.T function

CONFIDENCE.T (alpha; standard_label; size_)

Calculate the width of half the confidence interval for a Student's t-distribution function. .

CORREL function

CORREL (data_y; data_x)

Calculate r, the Pearson product moment correlation coefficient of a data set.

COUNT function

COUNT (value1; [value2, .])

Returns the total number of values ​​in a data set.

COVARIANCE.S function

COVARIANCE.S (data_y; data_x)

Calculate the covariance of a data set, in which the dataset is a sample of the entire population. .

EXPON.DIST

EXPON.DIST (x; lambda; cumulative)

Returns the value of the exponential distribution function with a given lambda at a specified value. .

FORECAST function

FORECAST (x, data_y; data_x)

Predict the y value for a specified x based on linear regression of a data set.

GAMMA function

GAMMA (number)

Returns the Gamma function evaluated at the specified value. .

GAMMA.INV function

GAMMA.INV (probability; alpha; beta)

The GAMMA.INV function returns the inverse of the gamma cumulative distribution function for the specified probability as well as the beta and alpha parameters. .

GAUSS function

GAUSS (z)

The GAUSS function returns the probability that a random variable, derived from a normal distribution function, will lie between the mean standard deviation and z above (or below) the mean. .

HYPGEOMDIST function

HYPGEOMDIST (ordinal_success; number_traction_sunition; frequency_construct_conventions; merge_size)

Calculate the probability of withdrawing a certain number of successes in a given number of tests, given a given set of dimensions, containing a certain number of successes, without redeploying the draws .

LARGE function

LARGE (data; n)

Returns the nth largest element of a data set, where n is user defined.

MAX function

MAX (value1; [value2, .])

Returns the maximum value in a numeric data set.

MEDIAN function

SCOPE (value1; [value2; .])

Returns the average value in a numeric data set.

MIN function

MIN (value_1; [value_2; .])

Returns the smallest value in a numeric data set.

MODE function

MODE (value1; [value2; .])

Returns the most frequent value in a dataset.

MODE.MULT function

MODE.MULT (value1; value2)

Returns the most frequent value in a dataset. .

NORMDIST function

NORMDIST (x; mean_value; standard_deviation; cumulative)

Returns the value of the standard distribution function (or standard cumulative distribution function) for a specified value, mean, and standard deviation.

PERCENTILE function

PERCENTILE (data; percentile)

Returns the value at a given percentile of a data set.

PERCENTILE.EXC function

PERCENTILE.EXC (data; percentile)

Returns the value at a given percentile of a data set between 0 and 1.

PERCENTRANK function

PERCENTRANK (data; value; [numerals_value])

Returns the percentage rank (percentile) of a specified value in a dataset.

PERCENTRANK.EXC function

PERCENTRANK.EXC (data; value; [numerals_value])

Returns the percentage rank (percentile) from 0 to 1 regardless of a specific value in a data set.

PERCENTRANK.INC function

PERCENTRANK.INC (data; value; [numerals_value])

Returns the percentage rank (percentile) from 0 to 1 including a specified value in a dataset.

PERMUTATIONA function

PERMUTATIONA (number_selected)

Returns the number of permutations to select a group of objects (with substitution) in the total number of objects. .

PHI function

PHI (x)

The PHI function returns the value of the standard distribution function whose mean value is 0 and the standard deviation is 1.

POISSON.DIST

POISSON.DIST (x; average_value; [cumulative])

Returns the value of the Poisson distribution function (or Poisson cumulative distribution function) for a specified value and mean. .

QUARTILE function

QUARTILE (data; decimal_name)

Returns the closest value to a specific quartile of a data set.

QUARTILE.EXC function

QUARTILE.EXC (data; decimal_name)

Returns the nearest value for a specific quartile of a data set between 0 and 4.

RANK function

RANK (value; data; [increasing])

Returns the rank of a specified value in a dataset.

RANK.AVG function

RANK.AVG function (value; data; [increasing])

Returns the rank of a specified value in a dataset. If the data set has multiple values ​​with the same rank, the function will return the average rank of the entries.

RANK.EQ function

RANK.EQ (value; data; [increasing])

Returns the rank of a specified value in a dataset. If there is more than one entry of the same value in the data set, the function will return the highest rank of the entries.

SKEW.P function

SKEW.P (value1; value2)

Calculate the deviation of a data set that represents the entire population. .

SLOPE function

SLOPE (data_y; data_x)

Calculate the slope of a linear regression line for a data set.

STDEV function

STDEV (value_1; [value_2; .])

Calculate the standard deviation based on a sample.

T.DIST

T.DIST (x; degrees_freedom; cumulative)

Returns the right-tailed Student distribution function for x value. .

T.DIST.2T

T.DIST.2T (x; degrees_freedom)

Returns the two-tailed Student distribution function for x values. .

T.DIST.RT function

T.DIST.RT (x; degrees_freedom)

Returns the right-tailed Student distribution for the value x. .

T.TEST function

T.TEST (range_1; range_2; side; type)

Returns the probability associated with Student's t-test. Determine whether the two samples are likely to originate from the two original sets having the same mean. .

TDIST function

TDIST (x; degrees_freedom; tail)

Calculate the probability for Student's t-distribution with the given input (x).

VAR function

VAR (value1, [value2, .])

Calculate variance based on a sample.

Z.TEST function

Z.TEST (data; value; [standard_deviation])

Returns the one-sided P value of the Z-test with standard distribution function. .

COUNTA function

COUNTA (value_1; [value_2; .])

Returns the total number of values ​​in a dataset.

5. Technical functions

BITAND function

BITAND (value1; value2)

Boolean reverses the AND bit of two numbers.

BITLSHIFT function

BITLSHIFT (value; transfer_value)

Moves the bits of the entered number to the left of the positions.

BITOR function

BITOR (value1; value2)

Boolean reverses the OR bit of two numbers.

BITRSHIFT function

BITRSHIFT (value; transfer_value)

Moves the bits of the entered number into the right positions.

BITXOR function

BITXOR (value1; value2)

Inverts the XOR bit (excluding the OR function) of the two numbers.

COMPLEX function

COMPLEX (real_part; part_;; [suffix])

Create a complex number that is given to the real and virtual coefficients

DELTA function

DELTA (number 1; [number 2])

Comparing 2 numeric values, returns 1 if they are equal.

ERF function

ERF (lower_limit; [upper_limit])

The ERF function returns the integral of the Gauss error function in a range of values. .

GESTEP function

GESTEP (value, [steps])

Returns 1 if the ratio is greater than or equal to the step value provided or 0 otherwise. If no step value is provided, the default value is 0.

HEX2DEC function

HEX2DEC (decimal_number_range)

Convert signed hexadecimal numbers to decimal format.

IMABS function

IMABS (number)

Returns the absolute value of a complex number.

IMAGINARY function

IMAGINARY (number_company)

Returns the imaginary coefficient of a complex number.

IMARGUMENT function

IMARGUMENT (number)

The IMARGUMENT function returns the angle (also called the argument or theta) of the given complex number in radians. .

IMCONJUGATE

IMCONJUGATE (number)

Returns the complex conjugate of a number.

IMCOS function

IMCOS (number)

The IMCOS function returns the cosine of a given complex number. .

IMCOSH function

IMCOSH (number)

Returns the hyperbolic cosine of a given complex number. For example, a complex number that gave "x + yi" returns "cosh (x + yi)". .

IMCOT function

IMCOT (number)

Returns the cotang of a given complex number. For example, a given complex number "x + yi" returns "cot (x + yi)". .

IMCOTH function

IMCOTH (number)

Returns the hyperbolic cotangent of a given complex number. For example, a complex number that gave "x + yi" returns "coth (x + yi)". .

IMCSC

IMCSC (number)

Returns the cosec of the complex number given. .

IMCSCH function

IMCSCH (number)

Returns the hyperbolic cosec of a given complex number. For example, a complex number that gave "x + yi" returns "csch (x + yi)". .

IMDIV function

IMDIV (number_number; number_chia)

Returns a complex number divided by another complex number.

IMEXP

IMEXP (number_guards)

Returns the Euler number, e (~ 2.718) raised to a complex power. .

IMLOG

IMLOG (value; basis)

Returns the logarithm of a complex number with a specified base number. .

IMLOG10 function

IMLOG10 (value)

Returns the logarithm of a complex number with base 10.

IMLOG2 function

IMLOG2 (value)

Returns the logarithm of a complex number with base 2.

IMPRODUCT function

IMPRODUCT (excess_1; [excess__2; .])

Returns the result when multiplying a series of complex numbers together.

IMREAL function

IMREAL (number_company)

Returns the real coefficient of a complex number.

IMSEC function

IMSEC (number)

Returns the sec of a given complex number. For example, a complex number that gave "x + yi" returns "sec (x + yi)". .

IMSECH function

IMSECH (number)

Returns the hyperbolic sec of a given complex number. For example, a complex number that gave "x + yi" returns "sec (x + yi)". .

IMSIN

IMSIN (number)

Returns the sine of a given complex number. .

IMSINH function

IMSINH (number)

Returns the hyperbolic sine of a given complex number. For example, a complex number that gave "x + yi" returns "sinh (x + yi)". .

IMSUB function

IMSUB (first_name; second_name)

Returns the difference of two complex numbers.

IMSUM function

IMSUM (value1; [value2; .])

Returns the sum of a sequence of complex numbers.

IMTAN

IMTAN (number)

Returns the tangent of the given complex number. .

IMTANH function

IMTANH (number)

Returns the hyperbolic tangent of the given complex number. For example, a given complex number "x + yi" returns "tanh (x + yi)". .

6. Filter function

FILTER function

FILTER (range; condition1; [condition2])

Returns a filtered version of the source range, returning only rows or columns that meet the specified conditions.

SORT function

SORT (range; sorted_range; ascending; [sorted2 column]; [ascending2])

Sorts rows of a given array or range of values ​​by one or more columns.

UNIQUE function

UNIQUE (range_)

Returns unique rows in a given source range, discarding duplicate rows. Rows are returned in the order they first appeared in the source range.

7. Array function

ARRAY_CONSTRAIN function

ARRAY_CONSTRAIN (first range; number_ row; number_column)

Constraints an array value to a specified size.

FREQUENCY function

FREQUENCY (data, layer)

Calculates the frequency distribution of values ​​in a column, based on given classes.

GROWTH function

GROWTH (known_data_y; data_data_x]; [new_data_x]; [b])

Give a portion of the data about an exponential growth trend, find the appropriate exponential growth trend and / or predict further value.

LINEST function

LINEST (known_data_y; data_data_x], [calculated_b], [details])

Given a piece of data about a linear trend, calculate the parameters for the ideal linear trend using the least square method.

MMULT function

MMULT (match1; match2)

Calculates the matrix product of 2 specified matrices as an array or range.

SUMPRODUCT function

SUMPRODUCT (array1; [array2; .])

Calculates the sum of the products of corresponding elements in two equal-sized arrays or ranges.

SUMX2MY2 function

SUMX2MY2 (array_x; array_y)

Calculate the sum of the difference of squares of values ​​in two arrays.

SUMXMY2 function

SUMXMY2 (array_x; array_y)

Calculate the sum of squares of differences of values ​​in 2 arrays.

TRANSPOSE function

TRANSPOSE (array_or_range)

Transpose the rows and columns of an array or range.

TREND function

TREND (known_data_y; data_data_x]; [new_data_x]; [b])

Given a piece of data about a linear trend, find an appropriate linear trend using the least squares method and / or add value predictions.

8. The function of the date

DATE function

DATE (year, month, day)

Convert a given year, month, and day to a date (in calendar).

DATEDIF function

DATEDIF (start_date; end_date; unit)

Calculate the number of days, months or years between two dates.

DATEVALUE function

DATEVALUE (string_day_month)

Converts a given date string in a known format into a date value.

The DAY function

DAY (days)

Returns the day number of the month, based on a given date value, in numeric format.

DAYS function

DAYS (end_date; start_date)

Returns the number of days between two dates.

DAYS360 function

DAYS360 (start_date; end_date; [method])

Returns the number of days between two dates on the basis of a 360-day year used in some financial interest calculations.

EDATE function

EDATE (start_date; months)

Returns a date (in calendar) before or after a specified number of months from another ((calendar)) date.

EOMONTH function

EOMONTH (start_date; months)

Returns the date representing the last day of a month before or after a number of months from another date.

HOUR function

HOUR (hours)

Returns the hour component of a specific time, in numeric format.

MINUTE function

MINUTE (time_gian)

Returns the minute component of a specific time, in numeric format.

MONTH function

MONTH (day_month)

Returns the month of the year based on a given date, in numeric format.

NETWORKDAYS function

NETWORKDAYS (start_date; end_date; [date_date])

Returns the number of actual business days between two given days.

NETWORKDAYS.INTL function

NETWORKDAYS.INTL (start_date; end_month; end_day_day;; [date_date])

Returns the number of actual working days between two given days, excluding specific holidays and weekends.

NOW function

NOW ()

Returns the current date and time as a date value.

SECOND function

SECOND (time)

Returns the second component of a specific time, in numeric format.

TIME

TIME (hours; minutes; seconds)

Converts a given hour, minute, and second to hours.

TIMEVALUE function

TIMEVALUE (string_hours)

Returns the fraction of a 24-hour day corresponding to a given time.

TODAY function

TODAY ()

Returns the current date as a date value.

WEEKDAY function

WEEKDAY (date, [type])

Returns a number representing the day of the week of the given date.

WEEKNUM function

WEEKNUM (day_month; [type])

Returns the week number of the year based on a given date.

WORKDAY function

WORKDAY (start_date_date; days_date; [date_date])

Calculates the end date after the specified number of working days.

WORKDAY.INTL function

WORKDAY.INTL (start_date; start_date; [last_day_day]; [date_date])

Calculate dates after a specific number of working days, excluding specific holidays and weekends.

YEAR function

YEAR (days)

Returns the year specified with a given date.

YEARFRAC function

YEARFRAC (start_date; end_date; [date_date])

Returns the number of years, including the fraction of the year, between two dates using a specified date counting convention.

9. Financial functions

AMORLINEC function

AMORLINC (cost; purchase_date; first_implementation; return_value; rate; [basis])

Returns the depreciation for the accounting period or pro-rated depreciation if the asset is purchased in the middle of the period.

COUPDAYSNC function

COUPDAYSNC (settlement_date; maturity_date; frequency; [daily_date]]

Calculate the number of days from the settlement date until the next interest payment or coupon payment.

DURATION function

DURATION (settlement_date; maturity_date; interest_interest; interest; frequency; [daily_date]).

Calculates the number of periods of compound interest required for an investment of the present value determined when judging at a given rate to reach the target value.

FV function

FV (interest_date, term_payment, payment_value, [current value], [end_or_date])

Calculate the future value of an annuity investment based on periodic equal payments and a constant interest rate.

INTRATE function

INTRATE (purchase_date; sell_date; purchase_date; sale_date; [daily_date]]

Calculates the actual interest rate that arises when buying an investment at one price and selling at another price without the interest or dividends generated by the investment itself.

IPMT function

IPST (yield_period; period_value; current value; [value_value]; [end_or_date])

Calculate interest payment for an investment based on periodic equal payments and constant interest rates.

IRR function

IRR (payout_payment; [rate of return]

Calculate the internal rate of return on an investment based on a series of periodic cash flows.

ISPM function

ISPMT (interest_period; period_value; current value)

The ISPMT function calculates the interest payable for a specific period of time for an investment. .

NPER function

NPER (yield_payment; payment_value; current value; [value_value]; [ending_or_development])

Calculates the number of payment periods for an investment based on periodic equal payments and a constant interest rate.

NPV function

NPV (discount_top; money1 stream; [cashflow2; .])

Calculates the net present value of an investment based on a series of periodic cash flows and discount rates.

PDURATION function

PDURATION (interest rate; current value; future_value)

Returns the number of periods for an investment to reach a specific value at a given rate. .

PMT function

PMT (interest_value; period_value; current_value; [future_value]; [end_or_development])

Calculation of periodic payments for annuity investments based on periodic equal payments and constant interest rates.

PPMT function

PPMT (interest_period; term; period; current value; [fair_value]; [ending or starting_)]

Calculate the principal payment of an investment based on periodic equal payments and a constant interest rate.

PRICEMAT function

PRICEMAT (settlement_date; maturity_date ;_date_date; interest_interest; interest; [daily_date]]

Calculate the price of security paying interest at maturity, based on expected yield.

PV function

PV (interest_due; period_value; current_value; payment_value; [future_value]; [ending_or_development])

Calculates the present value of an annuity investment based on periodic equal payments and a constant interest rate.

RECEIVED function

RECEIVED (settlement_date; maturity_date; investment_date; discount; [daily_date])

Calculates the amount received at maturity for an investment in fixed-income securities purchased on a date.

RRI function

RRI (period_value; current_value; future_value)

Returns the interest rate required for an investment to reach a specific value in a given period. .

VDB function

VDB (cost; return_value; period_activity; start_start period; end_value; [factor]; [non-conversion])

Returns the depreciation of an asset for a specific period (or a fraction of a period). .

XIRR function

XIRR (payoff_payment; pay_date_date_value; [Deluxeguess])

Calculates the internal rate of return of an investment based on a series of potentially non-recurring cash flows.

YIELDDISC function

YIELDDISC (settlement_date; maturity_date; price; refund_value; [daily_date]]

Calculates the annual yield of a discounted stock (without interest), based on price.

10. Information function

ISBLANK function

ISBLANK (value)

Checks whether the referenced cell is blank.

ISDATE function

ISDATE (value)

Returns whether the value is a date.

ISEMAIL function

ISEMAIL function (value)

Check if the value is a valid email address.

ISERROR function

ISERROR (value)

Checks whether the value is an error or not.

ISLOGICAL function

ISLOGICAL (value)

Checks whether the value is `TRUE` or` FALSE`.

ISNA function

ISNA (value)

Checks whether the value is a `# N / A` error.

ISNUMBER function

ISNUMBER (value)

Checks whether the value is a number or not.

ISTEXT function

ISTEXT (value)

Checks whether the value is text.

N function

N (value)

Returns the argument provided as a number.

NA function

NA ()

Returns the "invalid" error, `# N / A`.

TYPE function

TYPE (value)

Returns a number corresponding to the type of data included in the function.

CELL function

CELL (info_type; reference)

Returns the required information for a specific cell.

11. Search function

ADDRESS function

ADDRESS (row, column, [absolute_mode], [use_range1], [worksheet])

Returns a cell reference as a string.

CHOOSE function

CHOOSE (index, choice1, [choice2, .])

Returns the element from the list of options based on the index.

COLUMN function

COLUMN ([reference]]

Returns the column number of a specified cell, with `A = 1`.

COLUMNS function

COLUMNS (range_)

Returns the number of columns in a specified array or range.

FORMULATEXT function

FORMULATEXT (cell)

Returns the formula as a string. .

HLOOKUP function

HLOOKUP (search_key, range, index, [sorted]]

Search horizontally. Searches across the first row of the range for a key and returns the value of a specified cell in the column found.

INDEX function

INDEX (reference, [row], [column])

Returns the content of a cell, determined by the difference between rows and columns

INDIRECT function

INDIRECT (string_reference_string, [is_language_A1])

Returns a cell reference specified by a string.

LOOKUP function

LOOKUP (search_key; search_range | search_array_search results; [search_range])

Finds a key in a row or column and returns the value of the cell in a result range located in the same position as the search row or column.

MATCH function

MATCH (search_key, range, [search_type])

Returns the relative position of an item in the range that matches a specified value.

OFFSET function

OFFSET (parameter_reference, minus_true row, minus_column column, [height_size], [width]

Returns the reference of the converted range of rows and columns from a starting cell reference.

ROW function

ROW ([reference])

Returns the number of rows of a specified cell.

ROWS function

ROWS (range_)

Returns the number of rows in a specified array or range.

VLOOKUP function

VLOOKUP (search_key; range; index; [sorted]]

Search vertically. Search vertically the first column of the range for a key and returns the value of a specified cell in the found row.

12. Math functions

COTH

COTH (value)

Returns the hyperbolic cotangent of any real number. .

CSC

CSC (angle)

Returns the cosec of the given angle in radians. .

ABS function

ABS (value)

Returns the absolute value of a number.

CEILING function

CEILING (value, [coefficients])

Rounds a number up to the nearest significant integer multiple.

CEILING.PRECISE function

CEILING.PRECISE (number; [multidirectory])

Rounds a number up to the nearest integer multiple of the specified number. If positive or negative, this value is rounded up.

COMBIN function

COMBIN (n, k)

Returns the number of ways to select the number of objects in a combination of objects of a given size

COMBINA

COMBINA (n; k)

Returns the number of ways to select several objects in a combination of objects of a given size, including how to select the same object multiple times. .

COT function

COT (angle)

Cotang of the given angle, in radians. .

COUNTBLANK function

COUNTBLANK (range_)

Returns the number of empty cells in a given range.

COUNTIF function

COUNTIF (range, criteria)

Returns the conditional count on a range.

COUNTIFS function

COUNTIFS (criteria_range1; criteria1; [criteria_range2; criterion2; .])

Returns the count of a range based on multiple criteria.

COUNTUNIQUE function

COUNTUNIQUE (value1; [value2; .])

Counts the unique number of values ​​in a list of specified values ​​and ranges.

CSCH function

CSCH (value)

The CSCH function returns the hyperbolic cosec of any real number. .

DECIMAL function

DECIMAL (value; basis)

The DECIMAL function converts the textual representation of a number in another base, into base 10 (decimal). .

DEGREES function

DEGREES (angle)

Convert angle values ​​in radians to degrees.

FLOOR function

FLOOR (value, [coefficient])

Rounds a number down to the nearest significant integer multiple.

FLOOR.MATH

FLOOR.MATH (number; [multiples_range]; [mode])

Rounds a number down to the nearest integer multiple of the specified number, with negative numbers rounded to 0 or rounded up according to the mode.

FLOOR.PRECISE function

FLOOR.PRECISE (number; [multiples_number])

The FLOOR.PRECISE function rounds a number to the nearest integer or the nearest significant multiple. .

INT function

INT (value)

Rounds a number down to the nearest integer less than or equal to itself.

LOG function

LOG (value, base)

Returns the logarithm of a number based on a base.

MOD function

MOD (number_divided, number_chia)

Returns the result of the module operator, the remainder after a division operation.

MROUND function

MROUND (value, coefficients)

Rounds a number to the nearest integer multiple of another number.

MUNIT function

MUNIT (ordinal)

Returns a unit matrix of size ax b. .

POWER function

POWER (base, number_unit)

Returns a number raised to a power.

PRODUCT

PRODUCT (coefficient_1, [coefficient_2, .])

Returns the result when multiplying a sequence of numbers together.

QUOTIENT function

QUOTIENT (number_dated, number_chia)

Returns a number divided by another number.

RAND function

RAND ()

Returns a random number from 0 to less than 1.

RANDARRAY

RANDARRAY (row; column)

Generates a sequence of random numbers between 0 and 1.

RANDBETWEEN function

RANDBETWEEN (low, high)

Returns a constant random integer between two values, including these two values.

Jaw

Update 21 June 2020
Category

System

Mac OS X

Hardware

Game

Tech info

Technology

Science

Life

Application

Electric

Program

Mobile