Page 5 of 11
GROWTH
Given partial data about an exponential growth trend, fits an ideal exponential growth trend and/...
GROWTH(known_data_y, [known_data_x], [new_data_x], [b])
GT
Returns `TRUE` if the first argument is strictly greater than the second, and `FALSE` otherwise. ...
GT(value1, value2)
GTE
Returns `TRUE` if the first argument is greater than or equal to the second, and `FALSE` otherwis...
GTE(value1, value2)
HARMEAN
Calculates the harmonic mean of a dataset.
HARMEAN(value1, value2)
HEX2BIN
Converts a signed hexadecimal number to signed binary format.
HEX2BIN(signed_hexadecimal_number, [significant_digits])
HEX2DEC
Converts a signed hexadecimal number to decimal format.
HEX2DEC(signed_hexadecimal_number)
HEX2OCT
Converts a signed hexadecimal number to signed octal format.
HEX2OCT(signed_hexadecimal_number, significant_digits)
HLOOKUP
Horizontal lookup. Searches across the first row of a range for a key and returns the value of a ...
HLOOKUP(search_key, range, index, [is_sorted])
HOUR
Returns the hour component of a specific time, in numeric format.
HOUR(time)
HSTACK
Appends arrays horizontally and in sequence to return a larger array.
HSTACK(range1, [range2, ...])
HYPERLINK
Creates a hyperlink inside a cell.
HYPERLINK(url, [link_label])
HYPGEOM.DIST
See HYPGEOMDIST
HYPGEOM.DIST(num_successes, num_draws, successes_in_pop, pop_size)
HYPGEOMDIST
Calculates the probability of drawing a certain number of successes in a certain number of tries ...
HYPGEOMDIST(num_successes, num_draws, successes_in_pop, pop_size)
IF
Returns one value if a logical expression is `TRUE` and another if it is `FALSE`.
IF(logical_expression, value_if_true, value_if_false)
IFERROR
Returns the first argument if it is not an error value, otherwise returns the second argument if ...
IFERROR(value, [value_if_error])
IFNA
Evaluates a value. If the value is an #N/A error, returns the specified value..
IFNA(value, value_if_na)
IFS
Evaluates multiple conditions and returns a value that corresponds to the first true condition..
IFS(condition1, value1, [condition2, value2], …)
IMABS
Returns absolute value of a complex number.
IMABS(number)
IMAGE
Inserts an image into a cell.
IMAGE(url, [mode], [height], [width])
IMAGINARY
Returns the imaginary coefficient of a complex number.
IMAGINARY(complex_number)
IMARGUMENT
The IMARGUMENT function returns the angle (also known as the argument or \theta) of the given com...
IMARGUMENT(number)
IMCONJUGATE
Returns the complex conjugate of a number.
IMCONJUGATE(number)
IMCOS
The IMCOS function returns the cosine of the given complex number..
IMCOS(number)
IMCOSH
Returns the hyperbolic cosine of the given complex number. For example, a given complex number "x...
IMCOSH(number)
IMCOT
Returns the cotangent of the given complex number. For example, a given complex number "x+yi" ret...
IMCOT(number)
IMCOTH
Returns the hyperbolic cotangent of the given complex number. For example, a given complex number...
IMCOTH(number)
IMCSC
Returns the cosecant of the given complex number..
IMCSC(number)
IMCSCH
Returns the hyperbolic cosecant of the given complex number. For example, a given complex number ...
IMCSCH(number)
IMDIV
Returns one complex number divided by another.
IMDIV(dividend, divisor)
IMEXP
Returns Euler's number, e (~2.718) raised to a complex power..
IMEXP(exponent)
IMLN
Returns the logarithm of a complex number, base e (Euler's number).
IMLN(complex_value)
IMLOG
Returns the logarithm of a complex number for a specified base..
IMLOG(value, base)
IMLOG10
Returns the logarithm of a complex number with base 10..
IMLOG10(value)
IMLOG2
Returns the logarithm of a complex number with base 2..
IMLOG2(value)
IMPORTDATA
Imports data at a given url in .csv (comma-separated value) or .tsv (tab-separated value) format.
IMPORTDATA(url)
IMPORTFEED
Imports a RSS or ATOM feed.
IMPORTFEED(url, [query], [headers], [num_items])
IMPORTHTML
Imports data from a table or list within an HTML page.
IMPORTHTML(url, query, index)
IMPORTRANGE
Imports a range of cells from a specified spreadsheet.
IMPORTRANGE(spreadsheet_url, range_string)
IMPORTXML
Imports data from any of various structured data types including XML, HTML, CSV, TSV, and RSS and...
IMPORTXML(url, xpath_query)
IMPOWER
Returns a complex number raised to a power.
IMPOWER(complex_base, exponent)
IMPRODUCT
Returns the result of multiplying a series of complex numbers together.
IMPRODUCT(factor1, [factor2, ...])
IMREAL
Returns the real coefficient of a complex number.
IMREAL(complex_number)
IMSEC
Returns the secant of the given complex number. For example, a given complex number "x+yi" return...
IMSEC(number)
IMSECH
Returns the hyperbolic secant of the given complex number. For example, a given complex number "x...
IMSECH(number)
IMSIN
Returns the sine of the given complex number..
IMSIN (number)
IMSINH
Returns the hyperbolic sine of the given complex number. For example, a given complex number "x+y...
IMSINH(number)
IMSQRT
Computes the square root of a complex number.
IMSQRT(complex_number)
IMSUB
Returns the difference between two complex numbers.
IMSUB(first_number, second_number)