Google Sheets Formulas
Google Sheets has hundreds of functions built in that can be used to create formulas to help with tasks such as performing calculations, manipulating data and generating results based on the data in your spreadsheets.
These functions are broken down into the following categories that are listed below:
- Array
- Database
- Date
- Engineering
- Filter
- Financial
- Info
- Logical
- Lookup
- Math
- Operator
- Parser
- Statistical
- Text
- Web
Array Functions
| Name | Parameters | |
|---|---|---|
ARRAY_CONSTRAIN |
(input_range, num_rows, num_cols) |
Learn More |
BYCOL |
(array_or_range, LAMBDA) |
Learn More |
FLATTEN |
(range1,[range2,...]) |
Learn More |
FREQUENCY |
(data, classes) |
Learn More |
GROWTH |
(known_data_y, [known_data_x], [new_data_x], [b]) |
Learn More |
LINEST |
(known_data_y, [known_data_x], [calculate_b], [verbose]) |
Learn More |
LOGEST |
(known_data_y, [known_data_x], [b], [verbose]) |
Learn More |
MAKEARRAY |
(rows, columns, LAMBDA) |
Learn More |
MAP |
(array1, [array2, ...], LAMBDA) |
Learn More |
MDETERM |
(square_matrix) |
Learn More |
MINVERSE |
(square_matrix) |
Learn More |
MMULT |
(matrix1, matrix2) |
Learn More |
REDUCE |
(initial_value, array_or_range, LAMBDA) |
Learn More |
SUMPRODUCT |
(array1, [array2, ...]) |
Learn More |
SUMXMY2 |
(array_x, array_y) |
Learn More |
TOCOL |
(array_or_range, [ignore], [scan_by_column]) |
Learn More |
TRANSPOSE |
(array_or_range) |
Learn More |
TREND |
(known_data_y, [known_data_x], [new_data_x], [b]) |
Learn More |
VSTACK |
(range1; [range2, ...]) |
Learn More |
Database Functions
| Name | Parameters | |
|---|---|---|
DAVERAGE |
(database, field, criteria) |
Learn More |
DCOUNT |
(database, field, criteria) |
Learn More |
DCOUNTA |
(database, field, criteria) |
Learn More |
DGET |
(database, field, criteria) |
Learn More |
DMAX |
(database, field, criteria) |
Learn More |
DMIN |
(database, field, criteria) |
Learn More |
DPRODUCT |
(database, field, criteria) |
Learn More |
DSTDEV |
(database, field, criteria) |
Learn More |
DSTDEVP |
(database, field, criteria) |
Learn More |
DSUM |
(database, field, criteria) |
Learn More |
DVAR |
(database, field, criteria) |
Learn More |
DVARP |
(database, field, criteria) |
Learn More |
Date Functions
| Name | Parameters | |
|---|---|---|
DATE |
(year, month, day) |
Learn More |
DATEDIF |
(start_date, end_date, unit) |
Learn More |
DATEVALUE |
(date_string) |
Learn More |
DAY |
(date) |
Learn More |
DAYS |
(end_date, start_date) |
Learn More |
DAYS360 |
(start_date, end_date, [method]) |
Learn More |
EDATE |
(start_date, months) |
Learn More |
EOMONTH |
(start_date, months) |
Learn More |
EPOCHTODATE |
(timestamp, [unit]) |
Learn More |
HOUR |
(time) |
Learn More |
ISOWEEKNUM |
(date) |
Learn More |
MINUTE |
(time) |
Learn More |
MONTH |
(date) |
Learn More |
NETWORKDAYS |
(start_date, end_date, [holidays]) |
Learn More |
NETWORKDAYS.INTL |
(start_date, end_date, [weekend], [holidays]) |
Learn More |
NOW |
() |
Learn More |
SECOND |
(time) |
Learn More |
TIME |
(hour, minute, second) |
Learn More |
TIMEVALUE |
(time_string) |
Learn More |
TODAY |
() |
Learn More |
WEEKDAY |
(date, [type]) |
Learn More |
WEEKNUM |
(date, [type]) |
Learn More |
WORKDAY |
(start_date, num_days, [holidays]) |
Learn More |
WORKDAY.INTL |
(start_date, num_days, [weekend], [holidays]) |
Learn More |
YEAR |
(date) |
Learn More |
YEARFRAC |
(start_date, end_date, [day_count_convention]) |
Learn More |
Engineering Functions
| Name | Parameters | |
|---|---|---|
BIN2DEC |
(signed_binary_number) |
Learn More |
BIN2HEX |
(signed_binary_number, [significant_digits]) |
Learn More |
BIN2OCT |
(signed_binary_number, [significant_digits]) |
Learn More |
BITAND |
(value1, value2) |
Learn More |
BITLSHIFT |
(value, shift_amount) |
Learn More |
BITOR |
(value1, value2) |
Learn More |
BITXOR |
(value1, value2) |
Learn More |
COMPLEX |
(real_part, imaginary_part, [suffix]) |
Learn More |
DEC2BIN |
(decimal_number, [significant_digits]) |
Learn More |
DEC2HEX |
(decimal_number, [significant_digits]) |
Learn More |
DEC2OCT |
(decimal_number, [significant_digits]) |
Learn More |
DELTA |
(number1, [number2]) |
Learn More |
ERF |
(lower_bound, [upper_bound]) |
Learn More |
ERF.PRECISE |
(lower_bound, [upper_bound]) |
Learn More |
GESTEP |
(value, [step]) |
Learn More |
HEX2BIN |
(signed_hexadecimal_number, [significant_digits]) |
Learn More |
HEX2DEC |
(signed_hexadecimal_number) |
Learn More |
HEX2OCT |
(signed_hexadecimal_number, significant_digits) |
Learn More |
IMABS |
(number) |
Learn More |
IMAGINARY |
(complex_number) |
Learn More |
IMARGUMENT |
(number) |
Learn More |
IMCONJUGATE |
(number) |
Learn More |
IMCOSH |
(number) |
Learn More |
IMEXP |
(exponent) |
Learn More |
IMLOG10 |
(value) |
Learn More |
IMPRODUCT |
(factor1, [factor2, ...]) |
Learn More |
IMREAL |
(complex_number) |
Learn More |
IMSIN |
(number) |
Learn More |
IMSINH |
(number) |
Learn More |
IMSUM |
(value1, [value2, ...]) |
Learn More |
IMTAN |
(number) |
Learn More |
IMTANH |
(number) |
Learn More |
OCT2BIN |
(signed_octal_number, [significant_digits]) |
Learn More |
OCT2DEC |
(signed_octal_number) |
Learn More |
OCT2HEX |
(signed_octal_number, [significant_digits]) |
Learn More |
Filter Functions
| Name | Parameters | |
|---|---|---|
FILTER |
(range, condition1, [condition2]) |
Learn More |
SORT |
(range, sort_column, is_ascending, [sort_column2], [is_ascending2]) |
Learn More |
SORTN |
(range, [n], [display_ties_mode], [sort_column1, is_ascending1], ...) |
Learn More |
Financial Functions
| Name | Parameters | |
|---|---|---|
ACCRINT |
(issue, first_payment, settlement, rate, redemption, frequency, [day_count_convention]) |
Learn More |
ACCRINTM |
(issue, maturity, rate, [redemption], [day_count_convention]) |
Learn More |
AMORLINC |
(cost, purchase_date, first_period_end, salvage, period, rate, [basis]) |
Learn More |
COUPDAYBS |
(settlement, maturity, frequency, [day_count_convention]) |
Learn More |
COUPDAYS |
(settlement, maturity, frequency, [day_count_convention]) |
Learn More |
COUPDAYSNC |
(settlement, maturity, frequency, [day_count_convention]) |
Learn More |
COUPNCD |
(settlement, maturity, frequency, [day_count_convention]) |
Learn More |
COUPNUM |
(settlement, maturity, frequency, [day_count_convention]) |
Learn More |
COUPPCD |
(settlement, maturity, frequency, [day_count_convention]) |
Learn More |
CUMIPMT |
(rate, number_of_periods, present_value, first_period, last_period, end_or_beginning) |
Learn More |
CUMPRINC |
(rate, number_of_periods, present_value, first_period, last_period, end_or_beginning) |
Learn More |
DB |
(cost, salvage, life, period, [month]) |
Learn More |
DDB |
(cost, salvage, life, period, [factor]) |
Learn More |
DISC |
(settlement, maturity, price, redemption, [day_count_convention]) |
Learn More |
DOLLARDE |
(fractional_price, unit) |
Learn More |
DOLLARFR |
(decimal_price, unit) |
Learn More |
DURATION |
(settlement, maturity, rate, yield, frequency, [day_count_convention]) . |
Learn More |
EFFECT |
(nominal_rate, periods_per_year) |
Learn More |
FV |
(rate, number_of_periods, payment_amount, [present_value], [end_or_beginning]) |
Learn More |
FVSCHEDULE |
(principal, rate_schedule) |
Learn More |
INTRATE |
(buy_date, sell_date, buy_price, sell_price, [day_count_convention]) |
Learn More |
IPMT |
(rate, period, number_of_periods, present_value, [future_value], [end_or_beginning]) |
Learn More |
IRR |
(cashflow_amounts, [rate_guess]) |
Learn More |
ISPMT |
(rate, period, number_of_periods, present_value) |
Learn More |
MDURATION |
(settlement, maturity, rate, yield, frequency, [day_count_convention]) |
Learn More |
MIRR |
(cashflow_amounts, financing_rate, reinvestment_return_rate) |
Learn More |
NOMINAL |
(effective_rate, periods_per_year) |
Learn More |
NPER |
(rate, payment_amount, present_value, [future_value], [end_or_beginning]) |
Learn More |
NPV |
(discount, cashflow1, [cashflow2, ...]) |
Learn More |
PDURATION |
(rate, present_value, future_value) |
Learn More |
PMT |
(rate, number_of_periods, present_value, [future_value], [end_or_beginning]) |
Learn More |
PPMT |
(rate, period, number_of_periods, present_value, [future_value], [end_or_beginning]) |
Learn More |
PRICE |
(settlement, maturity, rate, yield, redemption, frequency, [day_count_convention]) |
Learn More |
PRICEDISC |
(settlement, maturity, discount, redemption, [day_count_convention]) |
Learn More |
PRICEMAT |
(settlement, maturity, issue, rate, yield, [day_count_convention]) |
Learn More |
PV |
(rate, number_of_periods, payment_amount, [future_value], [end_or_beginning]) |
Learn More |
RATE |
(number_of_periods, payment_per_period, present_value, [future_value], [end_or_beginning], [rate_guess]) |
Learn More |
RRI |
(number_of_periods, present_value, future_value) |
Learn More |
SLN |
(cost, salvage, life) |
Learn More |
SYD |
(cost, salvage, life, period) |
Learn More |
TBILLEQ |
(settlement, maturity, discount) |
Learn More |
TBILLPRICE |
(settlement, maturity, discount) |
Learn More |
TBILLYIELD |
(settlement, maturity, price) |
Learn More |
VDB |
(cost, salvage, life, start_period, end_period, [factor], [no_switch]) |
Learn More |
XIRR |
(cashflow_amounts, cashflow_dates, [rate_guess]) |
Learn More |
XNPV |
(discount, cashflow_amounts, cashflow_dates) |
Learn More |
YIELD |
(settlement, maturity, rate, price, redemption, frequency, [day_count_convention]) |
Learn More |
YIELDDISC |
(settlement, maturity, price, redemption, [day_count_convention]) |
Learn More |
YIELDMAT |
(settlement, maturity, issue, rate, price, [day_count_convention]) |
Learn More |
Google Functions
| Name | Parameters | |
|---|---|---|
ARRAYFORMULA |
(array_formula) |
Learn More |
DETECTLANGUAGE |
(text_or_range) |
Learn More |
GOOGLEFINANCE |
(ticker, [attribute], [start_date], [end_date|num_days], [interval]) |
Learn More |
GOOGLETRANSLATE |
(text, [source_language], [target_language]) |
Learn More |
IMAGE |
(url, [mode], [height], [width]) |
Learn More |
QUERY |
(data, query, [headers]) |
Learn More |
SPARKLINE |
(data, [options]) |
Learn More |
Info Functions
| Name | Parameters | |
|---|---|---|
ERROR.TYPE |
(reference) |
Learn More |
ISBLANK |
(value) |
Learn More |
ISDATE |
(value) |
Learn More |
ISEMAIL |
(value) |
Learn More |
ISERR |
(value) |
Learn More |
ISERROR |
(value) |
Learn More |
ISFORMULA |
(cell) |
Learn More |
ISLOGICAL |
(value) |
Learn More |
ISNA |
(value) |
Learn More |
ISNONTEXT |
(value) |
Learn More |
ISNUMBER |
(value) |
Learn More |
ISREF |
(value) |
Learn More |
ISTEXT |
(value) |
Learn More |
N |
(value) |
Learn More |
NA |
() |
Learn More |
TYPE |
(value) |
Learn More |
CELL |
(info_type, reference) |
Learn More |
Logical Functions
| Name | Parameters | |
|---|---|---|
AND |
(logical_expression1, [logical_expression2, ...]) |
Learn More |
FALSE |
() |
Learn More |
IF |
(logical_expression, value_if_true, value_if_false) |
Learn More |
IFERROR |
(value, [value_if_error]) |
Learn More |
IFNA |
(value, value_if_na) |
Learn More |
IFS |
(condition1, value1, [condition2, value2], ...) |
Learn More |
LAMBDA |
(name, formula_expression) |
Learn More |
LET |
(name1, value_expression1, [name2, ...], [value_expression2, ...], formula_expression ) |
Learn More |
NOT |
(logical_expression) |
Learn More |
OR |
(logical_expression1, [logical_expression2, ...]) |
Learn More |
SWITCH |
(expression, case1, value1, [default or case2, value2], ...) |
Learn More |
TRUE |
() |
Learn More |
XOR |
(logical_expression1, [logical_expression2, ...]) |
Learn More |
Lookup Functions
| Name | Parameters | |
|---|---|---|
ADDRESS |
(row, column, [absolute_relative_mode], [use_a1_notation], [sheet]) |
Learn More |
CHOOSE |
(index, choice1, [choice2, ...]) |
Learn More |
COLUMN |
([cell_reference]) |
Learn More |
COLUMNS |
(range) |
Learn More |
FORMULATEXT |
(cell) |
Learn More |
GETPIVOTDATA |
(value_name, any_pivot_table_cell, [original_column, ...], [pivot_item, ...] |
Learn More |
HLOOKUP |
(search_key, range, index, [is_sorted]) |
Learn More |
INDEX |
(reference, [row], [column]) |
Learn More |
INDIRECT |
(cell_reference_as_string, [is_A1_notation]) |
Learn More |
LOOKUP |
(search_key, search_range|search_result_array, [result_range]) |
Learn More |
MATCH |
(search_key, range, [search_type]) |
Learn More |
OFFSET |
(cell_reference, offset_rows, offset_columns, [height], [width]) |
Learn More |
ROW |
([cell_reference]) |
Learn More |
ROWS |
(range) |
Learn More |
VLOOKUP |
(search_key, range, index, [is_sorted]) |
Learn More |
XLOOKUP |
(search_key, lookup_range, result_range, missing_value, [match_mode], [search_mode]) |
Learn More |
Math Functions
| Name | Parameters | |
|---|---|---|
ABS |
(value) |
Learn More |
ACOS |
(value) |
Learn More |
ACOSH |
(value) |
Learn More |
ACOT |
(value) |
Learn More |
ACOTH |
(value) |
Learn More |
ASIN |
(value) |
Learn More |
ASINH |
(value) |
Learn More |
ATAN |
(value) |
Learn More |
ATAN2 |
(x, y) |
Learn More |
ATANH |
(value) |
Learn More |
CEILING |
(value, [factor]) |
Learn More |
CEILING.MATH |
(number, [significance], [mode]) |
Learn More |
CEILING.PRECISE |
(number, [significance]) |
Learn More |
COMBIN |
(n, k) |
Learn More |
COMBINA |
(n, k) |
Learn More |
COS |
(angle) |
Learn More |
COSH |
(value) |
Learn More |
COT |
(angle) |
Learn More |
COTH |
(value) |
Learn More |
COUNTBLANK |
(range) |
Learn More |
COUNTIF |
(range, criterion) |
Learn More |
COUNTIFS |
(criteria_range1, criterion1, [criteria_range2, criterion2, ...]) |
Learn More |
COUNTUNIQUE |
(value1, [value2, ...]) |
Learn More |
CSC |
(angle) |
Learn More |
DECIMAL |
(value, base) |
Learn More |
DEGREES |
(angle) |
Learn More |
ERFC |
(z) |
Learn More |
ERFC.PRECISE |
(z) |
Learn More |
EVEN |
(value) |
Learn More |
EXP |
(exponent) |
Learn More |
FACT |
(value) |
Learn More |
FACTDOUBLE |
(value) |
Learn More |
FLOOR |
(value, [factor]) |
Learn More |
FLOOR.MATH |
(number, [significance], [mode]) |
Learn More |
FLOOR.PRECISE |
(number, [significance]) |
Learn More |
GAMMALN |
(value) |
Learn More |
GAMMALN.PRECISE |
(value) |
Learn More |
GCD |
(value1, value2) |
Learn More |
IMLN |
(complex_value) |
Learn More |
INT |
(value) |
Learn More |
ISEVEN |
(value) |
Learn More |
ISO.CEILING |
(number, [significance]) |
Learn More |
ISODD |
(value) |
Learn More |
LCM |
(value1, value2) |
Learn More |
LN |
(value) |
Learn More |
LOG |
(value, base) |
Learn More |
LOG10 |
(value) |
Learn More |
MOD |
(dividend, divisor) |
Learn More |
MROUND |
(value, factor) |
Learn More |
MULTINOMIAL |
(value1, value2) |
Learn More |
MUNIT |
(dimension) |
Learn More |
ODD |
(value) |
Learn More |
PI |
() |
Learn More |
POWER |
(base, exponent) |
Learn More |
PRODUCT |
(factor1, [factor2, ...]) |
Learn More |
QUOTIENT |
(dividend, divisor) |
Learn More |
RADIANS |
(angle) |
Learn More |
RAND |
() |
Learn More |
RANDARRAY |
(rows, columns) |
Learn More |
RANDBETWEEN |
(low, high) |
Learn More |
ROUND |
(value, [places]) |
Learn More |
ROUNDDOWN |
(value, [places]) |
Learn More |
ROUNDUP |
(value, [places]) |
Learn More |
SECH |
(value) |
Learn More |
SEQUENCE |
(rows, columns, start, step) |
Learn More |
SERIESSUM |
(x, n, m, a) |
Learn More |
SIGN |
(value) |
Learn More |
SIN |
(angle) |
Learn More |
SINH |
(value) |
Learn More |
SQRT |
(value) |
Learn More |
SQRTPI |
(value) |
Learn More |
SUBTOTAL |
(function_code, range1, [range2, ...]) |
Learn More |
SUM |
(value1, [value2, ...]) |
Learn More |
SUMIF |
(range, criterion, [sum_range]) |
Learn More |
SUMIFS |
(sum_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...]) |
Learn More |
SUMSQ |
(value1, [value2, ...]) |
Learn More |
TAN |
(angle) |
Learn More |
TANH |
(value) |
Learn More |
TRUNC |
(value, [places]) |
Learn More |
Operator Functions
| Name | Parameters | |
|---|---|---|
ADD |
(value1, value2) |
Learn More |
CONCAT |
(value1, value2) |
Learn More |
DIVIDE |
(dividend, divisor) |
Learn More |
EQ |
(value1, value2) |
Learn More |
GTE |
(value1, value2) |
Learn More |
ISBETWEEN |
(value_to_compare, lower_value, upper_value, lower_value_is_inclusive, upper_value_is_inclusive) |
Learn More |
MINUS |
(value1, value2) |
Learn More |
MULTIPLY |
(factor1, factor2) |
Learn More |
NE |
(value1, value2) |
Learn More |
POW |
(base, exponent) |
Learn More |
UMINUS |
(value) |
Learn More |
UNIQUE |
(range, by_column, exactly_once) |
Learn More |
UPLUS |
(value) |
Learn More |
Parser Functions
| Name | Parameters | |
|---|---|---|
CONVERT |
(value, start_unit, end_unit) |
Learn More |
TO_DATE |
(value) |
Learn More |
TO_DOLLARS |
(value) |
Learn More |
TO_PERCENT |
(value) |
Learn More |
TO_PURE_NUMBER |
(value) |
Learn More |
TO_TEXT |
(value) |
Learn More |
Statistical Functions
| Name | Parameters | |
|---|---|---|
AVEDEV |
(value1, [value2, ...]) |
Learn More |
AVERAGE |
(value1, [value2, ...]) |
Learn More |
AVERAGE.WEIGHTED |
(values, weights, [additional values], [additional weights]) |
Learn More |
AVERAGEA |
(value1, [value2, ...]) |
Learn More |
AVERAGEIF |
(criteria_range, criterion, [average_range]) |
Learn More |
AVERAGEIFS |
(average_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...]) |
Learn More |
BETA.DIST |
(value, alpha, beta, cumulative, lower_bound, upper_bound) |
Learn More |
BETA.INV |
(probability, alpha, beta, lower_bound, upper_bound) |
Learn More |
BETADIST |
(value, alpha, beta, lower_bound, upper_bound) |
Learn More |
BETAINV |
(probability, alpha, beta, lower_bound, upper_bound) |
Learn More |
BINOM.DIST |
(num_successes, num_trials, prob_success, cumulative) |
Learn More |
BINOM.INV |
(num_trials, prob_success, target_prob) |
Learn More |
BINOMDIST |
(num_successes, num_trials, prob_success, cumulative) |
Learn More |
CHIDIST |
(x, degrees_freedom) |
Learn More |
CHIINV |
(probability, degrees_freedom) |
Learn More |
CHISQ.DIST |
(x, degrees_freedom, cumulative) |
Learn More |
CHISQ.DIST.RT |
(x, degrees_freedom) |
Learn More |
CHISQ.INV |
(probability, degrees_freedom) |
Learn More |
CHISQ.INV.RT |
(probability, degrees_freedom) |
Learn More |
CHISQ.TEST |
(observed_range, expected_range) |
Learn More |
CHITEST |
(observed_range, expected_range) |
Learn More |
CONFIDENCE |
(alpha, standard_deviation, pop_size) |
Learn More |
CONFIDENCE.NORM |
(alpha, standard_deviation, pop_size) |
Learn More |
CONFIDENCE.T |
(alpha, standard_deviation, size) |
Learn More |
CORREL |
(data_y, data_x) |
Learn More |
COUNT |
(value1, [value2, ...]) |
Learn More |
COUNTA |
(value1, [value2, ...]) |
Learn More |
COVAR |
(data_y, data_x) |
Learn More |
COVARIANCE.P |
(data_y, data_x) |
Learn More |
COVARIANCE.S |
(data_y, data_x) |
Learn More |
CRITBINOM |
(num_trials, prob_success, target_prob) |
Learn More |
DEVSQ |
(value1, value2) |
Learn More |
EXPON.DIST |
(x, LAMBDA, cumulative) |
Learn More |
EXPONDIST |
(x, LAMBDA, cumulative) |
Learn More |
F.DIST |
(x, degrees_freedom1, degrees_freedom2, cumulative) |
Learn More |
F.DIST.RT |
(x, degrees_freedom1, degrees_freedom2) |
Learn More |
F.INV |
(probability, degrees_freedom1, degrees_freedom2) |
Learn More |
F.INV.RT |
(probability, degrees_freedom1, degrees_freedom2) |
Learn More |
F.TEST |
(range1, range2) |
Learn More |
FDIST |
(x, degrees_freedom1, degrees_freedom2) |
Learn More |
FINV |
(probability, degrees_freedom1, degrees_freedom2) |
Learn More |
FISHER |
(value) |
Learn More |
FISHERINV |
(value) |
Learn More |
FORECAST |
(x, data_y, data_x) |
Learn More |
FORECAST.LINEAR |
(x, data_y, data_x) |
Learn More |
FTEST |
(range1, range2) |
Learn More |
GAMMA |
(number) |
Learn More |
GAMMA.DIST |
(x, alpha, beta, cumulative) |
Learn More |
GAMMA.INV |
(probability, alpha, beta) |
Learn More |
GAMMADIST |
(x, alpha, beta, cumulative) |
Learn More |
GAMMAINV |
(probability, alpha, beta) |
Learn More |
GAUSS |
(z) |
Learn More |
GEOMEAN |
(value1, value2) |
Learn More |
HYPGEOM.DIST |
(num_successes, num_draws, successes_in_pop, pop_size) |
Learn More |
HYPGEOMDIST |
(num_successes, num_draws, successes_in_pop, pop_size) |
Learn More |
INTERCEPT |
(data_y, data_x) |
Learn More |
KURT |
(value1, value2) |
Learn More |
LARGE |
(data, n) |
Learn More |
LOGINV |
(x, mean, standard_deviation) |
Learn More |
LOGNORM.DIST |
(x, mean, standard_deviation) |
Learn More |
LOGNORM.INV |
(x, mean, standard_deviation) |
Learn More |
LOGNORMDIST |
(x, mean, standard_deviation) |
Learn More |
MAX |
(value1, [value2, ...]) |
Learn More |
MAXA |
(value1, value2) |
Learn More |
MAXIFS |
(range, criteria_range1, criterion1, [criteria_range2, criterion2], ...) |
Learn More |
MEDIAN |
(value1, [value2, ...]) |
Learn More |
MIN |
(value1, [value2, ...]) |
Learn More |
MINA |
(value1, value2) |
Learn More |
MINIFS |
(range, criteria_range1, criterion1, [criteria_range2, criterion2], ...) |
Learn More |
MODE |
(value1, [value2, ...]) |
Learn More |
MODE.MULT |
(value1, value2) |
Learn More |
MODE.SNGL |
(value1, [value2, ...]) |
Learn More |
NEGBINOM.DIST |
(num_failures, num_successes, prob_success) |
Learn More |
NEGBINOMDIST |
(num_failures, num_successes, prob_success) |
Learn More |
NORM.DIST |
(x, mean, standard_deviation, cumulative) |
Learn More |
NORM.INV |
(x, mean, standard_deviation) |
Learn More |
NORM.S.DIST |
(x) |
Learn More |
NORM.S.INV |
(x) |
Learn More |
NORMDIST |
(x, mean, standard_deviation, cumulative) |
Learn More |
NORMINV |
(x, mean, standard_deviation) |
Learn More |
NORMSDIST |
(x) |
Learn More |
NORMSINV |
(x) |
Learn More |
PEARSON |
(data_y, data_x) |
Learn More |
PERCENTILE |
(data, percentile) |
Learn More |
PERCENTILE.EXC |
(data, percentile) |
Learn More |
PERCENTILE.INC |
(data, percentile) |
Learn More |
PERCENTRANK |
(data, value, [significant_digits]) |
Learn More |
PERCENTRANK.EXC |
(data, value, [significant_digits]) |
Learn More |
PERCENTRANK.INC |
(data, value, [significant_digits]) |
Learn More |
PERMUTATIONA |
(number, number_chosen) |
Learn More |
PERMUT |
(n, k) |
Learn More |
PHI |
(x) |
Learn More |
POISSON |
(x, mean, cumulative) |
Learn More |
POISSON.DIST |
(x, mean, [cumulative]) |
Learn More |
PROB |
(data, probabilities, low_limit, [high_limit]) |
Learn More |
QUARTILE |
(data, quartile_number) |
Learn More |
QUARTILE.EXC |
(data, quartile_number) |
Learn More |
QUARTILE.INC |
(data, quartile_number) |
Learn More |
RANK |
(value, data, [is_ascending]) |
Learn More |
RANK.AVG |
(value, data, [is_ascending]) |
Learn More |
RANK.EQ |
(value, data, [is_ascending]) |
Learn More |
RSQ |
(data_y, data_x) |
Learn More |
SKEW |
(value1, value2) |
Learn More |
SKEW.P |
(value1, value2) |
Learn More |
SLOPE |
(data_y, data_x) |
Learn More |
SMALL |
(data, n) |
Learn More |
STANDARDIZE |
(value, mean, standard_deviation) |
Learn More |
STDEV |
(value1, [value2, ...]) |
Learn More |
STDEV.P |
(value1, [value2, ...]) |
Learn More |
STDEV.S |
(value1, [value2, ...]) |
Learn More |
STDEVA |
(value1, value2) |
Learn More |
STDEVP |
(value1, value2) |
Learn More |
STDEVPA |
(value1, value2) |
Learn More |
STEYX |
(data_y, data_x) |
Learn More |
T.DIST |
(x, degrees_freedom, cumulative) |
Learn More |
T.DIST.2T |
(x, degrees_freedom) |
Learn More |
T.DIST.RT |
(x, degrees_freedom) |
Learn More |
T.INV |
(probability, degrees_freedom) |
Learn More |
T.INV.2T |
(probability, degrees_freedom) |
Learn More |
T.TEST |
(range1, range2, tails, type) |
Learn More |
TDIST |
(x, degrees_freedom, tails) |
Learn More |
TINV |
(probability, degrees_freedom) |
Learn More |
TRIMMEAN |
(data, exclude_proportion) |
Learn More |
TTEST |
(range1, range2, tails, type) |
Learn More |
VAR |
(value1, [value2, ...]) |
Learn More |
VAR.P |
(value1, [value2, ...]) |
Learn More |
VAR.S |
(value1, [value2, ...]) |
Learn More |
VARA |
(value1, value2) |
Learn More |
VARP |
(value1, value2) |
Learn More |
VARPA |
(value1, value2,...) |
Learn More |
WEIBULL |
(x, shape, scale, cumulative) |
Learn More |
WEIBULL.DIST |
(x, shape, scale, cumulative) |
Learn More |
Z.TEST |
(data, value, [standard_deviation]) |
Learn More |
ZTEST |
(data, value, [standard_deviation]) |
Learn More |
Text Functions
| Name | Parameters | |
|---|---|---|
ARABIC |
(roman_numeral) |
Learn More |
ASC |
(text) |
Learn More |
CHAR |
(table_number) |
Learn More |
CLEAN |
(text) |
Learn More |
CODE |
(string) |
Learn More |
CONCATENATE |
(string1, [string2, ...]) |
Learn More |
DOLLAR |
(number, [number_of_places]) |
Learn More |
EXACT |
(string1, string2) |
Learn More |
FIND |
(search_for, text_to_search, [starting_at]) |
Learn More |
FINDB |
(search_for, text_to_search, [starting_at]) |
Learn More |
FIXED |
(number, [number_of_places], [suppress_separator]) |
Learn More |
JOIN |
(delimiter, value_or_array1, [value_or_array2, ...]) |
Learn More |
LEFT |
(string, [number_of_characters]) |
Learn More |
LEFTB |
(string, num_of_bytes) |
Learn More |
LEN |
(text) |
Learn More |
LENB |
(string) |
Learn More |
LOWER |
(text) |
Learn More |
MID |
(string, starting_at, extract_length) |
Learn More |
PROPER |
(text_to_capitalize) |
Learn More |
REGEXEXTRACT |
(text, regular_expression) |
Learn More |
REGEXMATCH |
(text, regular_expression) |
Learn More |
REGEXREPLACE |
(text, regular_expression, replacement) |
Learn More |
REPLACE |
(text, position, length, new_text) |
Learn More |
REPLACEB |
(text, position, num_bytes, new_text) |
Learn More |
REPT |
(text_to_repeat, number_of_repetitions) |
Learn More |
RIGHT |
(string, [number_of_characters]) |
Learn More |
RIGHTB |
(string, num_of_bytes) |
Learn More |
ROMAN |
(number, [rule_relaxation]) |
Learn More |
SEARCH |
(search_for, text_to_search, [starting_at]) |
Learn More |
SEARCHB |
(search_for, text_to_search, [starting_at]) |
Learn More |
SPLIT |
(text, delimiter, [split_by_each], [remove_empty_text]) |
Learn More |
SUBSTITUTE |
(text_to_search, search_for, replace_with, [occurrence_number]) |
Learn More |
T |
(value) |
Learn More |
TEXT |
(number, format) |
Learn More |
TEXTJOIN |
(delimiter, ignore_empty, text1, [text2], ...) |
Learn More |
TRIM |
(text) |
Learn More |
UNICHAR |
(number) |
Learn More |
UNICODE |
(text) |
Learn More |
UPPER |
(text) |
Learn More |
VALUE |
(text) |
Learn More |
Web Functions
| Name | Parameters | |
|---|---|---|
ENCODEURL |
(text) |
Learn More |
HYPERLINK |
(url, [link_label]) |
Learn More |
IMPORTDATA |
(url) |
Learn More |
IMPORTFEED |
(url, [query], [headers], [num_items]) |
Learn More |
IMPORTHTML |
(url, query, index) |
Learn More |
IMPORTRANGE |
(spreadsheet_url, range_string) |
Learn More |
IMPORTXML |
(url, xpath_query) |
Learn More |
ISURL |
(value) |
Learn More |
This table contains modified content from this Google Support article which itself is based upon Appendix B of the OpenOffice.org "Calc Guide," available at https://wiki.openoffice.org/w/images/b/b3/0300CS3-CalcGuide.pdf. This content is licensed under the Creative Commons Attribution License, version 2.0, available at https://creativecommons.org/licenses/by/2.0/legalcode.
The copyright notice found in the OpenOffice.org "Calc Guide" is included in its complete form below:
CopyrightThis document is Copyright © 2005 by its contributors as listed in the section titled Authors. You can distribute it and/or modify it under the terms of either the GNU General Public License, version 2 or later (https://www.gnu.org/licenses/gpl.html), or the Creative Commons Attribution License, version 2.0 or later (https://creativecommons.org/licenses/by/2.0/).
All trademarks within this guide belong to their legitimate owners.
Authors
- Magnus Adielsson
- Richard Barnes
- Peter Kupfer
- Iain Roberts
- Jean Hollis Weber