Google Sheets Formula Directory

Calculating the absolute value of a number to remove negativity for further calculations in Google Sheets

Calculating the inverse cosine (arccos) of a number, useful for trigonometry and angle calculations in Google Sheets.

Calculating the inverse hyperbolic cosine of a number, useful for advanced mathematical and engineering applications in Google Sheets.

Calculating the inverse sine (arcsin) of a number, useful in trigonometry and angle calculations in Google Sheets.

Calculating the arctangent of the quotient of its arguments, considering the signs of both arguments to determine the correct quadrant, useful for trigonometric calculations and geometry in Google Sheets.

Calculating the inverse hyperbolic tangent of a number, useful for advanced mathematical and engineering applications in Google Sheets.

Rounding a number up to the nearest multiple of a specified significance, useful for mathematical and financial applications in Google Sheets.

Calculating the number of ways to choose a given number of items from a set, without repetition, useful for combinatorics and statistical calculations in Google Sheets.

Calculating the cosine of an angle in Google Sheets, typically used in trigonometry, physics, and engineering calculations.

Calculating the hyperbolic cosine of a number in Google Sheets, useful in advanced mathematical and engineering applications.

Converts radians to degrees in Google Sheets, useful for trigonometric and mathematical conversions.

Rounds a number up to the nearest even integer in Google Sheets, often used for data formatting and rounding operations.

Calculates e raised to the power of a number in Google Sheets, commonly used in exponential growth models and mathematics.

Calculates the factorial of a number in Google Sheets, useful in combinatorics and probability calculations.

Calculates the double factorial of a number in Google Sheets, often used in advanced mathematical computations.

Rounds a number down to the nearest multiple of a specified factor in Google Sheets, useful for precision rounding.

Calculates the greatest common divisor of two or more numbers in Google Sheets, useful for simplifying fractions or number theory.

Rounds a number down to the nearest integer in Google Sheets, useful for truncating decimal values.

Calculates the least common multiple of two or more numbers in Google Sheets, useful for finding common denominators or scheduling.

Calculates the natural logarithm of a number in Google Sheets, essential for growth rate analysis and scientific calculations.

Calculates the logarithm of a number with a specified base in Google Sheets, useful for custom logarithmic scales.

Calculates the base-10 logarithm of a number in Google Sheets, commonly used in scientific and engineering calculations.

Calculates the determinant of a square matrix in Google Sheets, useful in linear algebra and matrix operations.

Calculates the inverse of a square matrix in Google Sheets, used in linear algebra for solving systems of equations.

Performs matrix multiplication in Google Sheets, essential for advanced linear algebra operations.

Returns the remainder after division in Google Sheets, useful for cyclic patterns or conditional formatting.

Rounds a number to the nearest multiple of a specified value in Google Sheets, useful for standardized rounding.

Calculates the multinomial coefficient of a set of numbers in Google Sheets, used in probability and combinatorics.

Rounds a number up to the nearest odd integer in Google Sheets, useful for specific formatting or data adjustments.

Returns the value of π (pi) in Google Sheets, essential for trigonometric and geometric calculations.

Raises a number to a specified power in Google Sheets, useful for exponential calculations.

Multiplies a range of numbers in Google Sheets, useful for calculating total products of values.

Returns the integer portion of a division in Google Sheets, useful for division without remainders.

Converts degrees to radians in Google Sheets, essential for trigonometric functions.

Generates a random number between 0 and 1 in Google Sheets, useful for simulations and random sampling.

Generates a random integer between two specified values in Google Sheets, useful for simulations or random selections.

Converts a number into Roman numerals in Google Sheets, useful for outlines or decorative formatting.

Rounds a number to a specified number of decimal places in Google Sheets, useful for precision control.

Rounds a number down to a specified number of decimal places in Google Sheets, useful for conservative estimates.

Rounds a number up to a specified number of decimal places in Google Sheets, useful for generous estimates.

Calculates the secant of an angle (in radians) in Google Sheets, used in trigonometric applications.

Calculates the hyperbolic secant of a number in Google Sheets, used in hyperbolic function applications.

Returns the sign of a number in Google Sheets (1, 0, or -1), useful for determining positivity or negativity.

Calculates the sine of an angle provided in radians in Google Sheets, commonly used in trigonometry and mathematical modeling.

Calculates the hyperbolic sine of a number in Google Sheets, often used in advanced mathematics and physics.

Calculates the square root of a number in Google Sheets, useful for mathematical and statistical operations.

Calculates the square root of a number multiplied by π (pi) in Google Sheets, often used in mathematical formulas.

Calculates a subtotal in a range using a specified function (e.g., sum, average) in Google Sheets, ignoring other subtotals.

Adds all numbers in a range or list in Google Sheets, a basic tool for totaling data.

Sums numbers in a range that meet a single criterion in Google Sheets, useful for conditional totaling.

Sums numbers in a range based on multiple criteria in Google Sheets, ideal for complex conditional summing.

Multiplies corresponding elements in arrays and sums the results in Google Sheets, useful for weighted sums.

Sums the squares of numbers in a range in Google Sheets, useful in statistical calculations like variance.

Calculates the tangent of an angle in radians in Google Sheets, used in trigonometry and slope calculations.

Calculates the hyperbolic tangent of a number in Google Sheets, used in hyperbolic function applications.

Truncates a number to a specified number of decimal places in Google Sheets, removing the fractional part.

Calculates the arithmetic mean of a range of numbers in Google Sheets, a basic statistical tool.

Calculates the mean of a range in Google Sheets, treating text as 0, unlike AVERAGE.

Calculates the average of a range based on a single criterion in Google Sheets, useful for conditional averaging.

Calculates the average of a range based on multiple criteria in Google Sheets, ideal for detailed analysis.

Counts the number of cells with numeric values in a range in Google Sheets, useful for tallying numbers.

Counts non-empty cells in a range in Google Sheets, including text and numbers, useful for tracking filled entries.

Counts the number of blank cells in a range in Google Sheets, useful for identifying missing data.

Counts cells in a range that meet a single criterion in Google Sheets, useful for conditional counting.

Counts cells in a range based on multiple criteria in Google Sheets, ideal for complex filtering.

Returns the maximum numeric value in a range in Google Sheets, useful for finding peaks.

Returns the maximum value in a range in Google Sheets, treating text as 0, unlike MAX.

Returns the median (middle value) of a range of numbers in Google Sheets, useful for central tendency.

Returns the minimum numeric value in a range in Google Sheets, useful for finding lows.

Returns the minimum value in a range in Google Sheets, treating text as 0, unlike MIN.

Returns the most frequently occurring value in a range in Google Sheets, useful for identifying trends.

Returns the value at a specified percentile in a range in Google Sheets, useful for statistical ranking.

Returns the value at a specified quartile in a range in Google Sheets, useful for dividing data into quarters.

Returns the rank of a number within a range in Google Sheets, useful for ordering data.

Calculates the sample standard deviation of a range in Google Sheets, measuring data spread.

Calculates the sample standard deviation in Google Sheets, treating text as 0, unlike STDEV.

Calculates the population standard deviation of a range in Google Sheets, for entire datasets.

Calculates the population standard deviation in Google Sheets, treating text as 0, unlike STDEVP.

Calculates the sample variance of a range in Google Sheets, measuring data dispersion.

Calculates the sample variance in Google Sheets, treating text as 0, unlike VAR.

Calculates the population variance of a range in Google Sheets, for entire datasets.

Calculates the population variance in Google Sheets, treating text as 0, unlike VARP.

Returns the character specified by a numeric code in Google Sheets, based on the ASCII table.

Removes non-printable characters from text in Google Sheets, useful for cleaning imported data.

Returns the numeric ASCII code of the first character in a text string in Google Sheets.

Combines two text strings into one in Google Sheets, useful for simple text concatenation.

Formats a number as a currency string with a dollar sign in Google Sheets, useful for financial displays.

Compares two text strings for exact equality in Google Sheets, case-sensitive, useful for validation.

Returns the position of a text string within another string in Google Sheets, case-sensitive.

Formats a number with a fixed number of decimals and optional commas in Google Sheets.

Extracts a specified number of characters from the start of a text string in Google Sheets.

Returns the length of a text string in Google Sheets, counting all characters including spaces.

Converts a text string to lowercase in Google Sheets, useful for standardizing text.

Extracts a substring from the middle of a text string in Google Sheets, based on position and length.

Capitalizes the first letter of each word in a text string in Google Sheets, useful for formatting names.

Replaces part of a text string with new text in Google Sheets, based on position and length.

Repeats a text string a specified number of times in Google Sheets, useful for creating patterns.

Extracts a specified number of characters from the end of a text string in Google Sheets.

Returns the position of a text string within another string in Google Sheets, case-insensitive.

Replaces specific text within a string with new text in Google Sheets, useful for text editing.

Formats a number as text using a specified format in Google Sheets, useful for custom displays.

Combines multiple text strings with a delimiter in Google Sheets, useful for bulk concatenation.

Removes extra spaces from text in Google Sheets, leaving single spaces between words.

Converts a text string to uppercase in Google Sheets, useful for standardization.

Converts a text string that represents a number into a numeric value in Google Sheets.

Returns TRUE if all conditions are true in Google Sheets, useful for logical tests.

Returns the logical value FALSE in Google Sheets, used in logical expressions.

Returns one value if a condition is true and another if false in Google Sheets, used for decision-making.

Returns a custom value if a formula results in an error in Google Sheets, useful for error handling.

Returns a custom value if a formula results in #N/A in Google Sheets, useful for specific error handling.

Evaluates multiple conditions and returns a value for the first true condition in Google Sheets.

Reverses the logical value of its argument in Google Sheets, useful for negating conditions.

Returns TRUE if any condition is true in Google Sheets, useful for multiple possibilities.

Evaluates an expression against a list of values and returns a corresponding result in Google Sheets.

Returns the logical value TRUE in Google Sheets, used in logical expressions.

Returns TRUE if an odd number of conditions are true in Google Sheets, useful for exclusive logic.

Creates a cell reference as text based on row and column numbers in Google Sheets.

Selects a value from a list based on an index number in Google Sheets.

Returns the column number of a specified cell in Google Sheets.

Returns the number of columns in a specified range in Google Sheets.

Searches for a value in the top row of a range and returns a value from a specified row below in Google Sheets.

Returns a value or reference from a range at a specified row and column position in Google Sheets.

Returns a reference specified by a text string in Google Sheets, enabling dynamic cell references.

Searches for a value in a range and returns a corresponding value from another range in Google Sheets.

Returns the relative position of a value in a range in Google Sheets, useful for lookups.

Returns a range reference shifted by a specified number of rows and columns in Google Sheets.

Returns the row number of a specified cell in Google Sheets.

Returns the number of rows in a specified range in Google Sheets.

Flips a range of cells from rows to columns or vice versa in Google Sheets.

Searches for a value in the first column of a range and returns a value from a specified column in Google Sheets.

Searches a range for a value and returns a corresponding value with advanced options in Google Sheets.

Returns the relative position of a value in a range with advanced options in Google Sheets.

Creates a date from year, month, and day values in Google Sheets.

Calculates the difference between two dates in various units (e.g., days, months) in Google Sheets.

Converts a date string into a serial number representing the date in Google Sheets.

Extracts the day of the month from a date in Google Sheets.

Calculates the number of days between two dates in Google Sheets.

Calculates days between two dates using a 360-day year in Google Sheets, common in financial calculations.

Returns a date a specified number of months before or after a start date in Google Sheets.

Returns the last day of a month a specified number of months from a start date in Google Sheets.

Extracts the hour from a time value in Google Sheets.

Returns the ISO week number of a given date in Google Sheets.

Extracts the minute from a time value in Google Sheets.

Extracts the month from a date in Google Sheets.

Calculates the number of working days between two dates in Google Sheets, excluding weekends and holidays.

Returns the current date and time in Google Sheets.

Extracts the seconds from a time value in Google Sheets.

Creates a time value from hour, minute, and second components in Google Sheets.

Converts a time string into a decimal representing the time fraction of a day in Google Sheets.

Returns the current date in Google Sheets.

Returns the day of the week as a number for a given date in Google Sheets.

Returns the week number of a given date in Google Sheets.

Returns a date a specified number of workdays before or after a start date in Google Sheets, excluding weekends and holidays.

Extracts the year from a date in Google Sheets.

Calculates the fraction of a year between two dates in Google Sheets.

Applies a formula to an entire range of cells in Google Sheets, enabling array operations.

Extracts rows from a range that meet specified criteria in Google Sheets.

Converts a range or multiple ranges into a single column in Google Sheets.

Imports data from a URL in CSV or TSV format into Google Sheets.

Imports a range of cells from another Google Sheets document.

Imports data from an XML or HTML source using an XPath query in Google Sheets.

Imports data from an HTML table or list on a webpage into Google Sheets.

Runs a SQL-like query on a range of data in Google Sheets.

Divides a text string into separate columns based on a delimiter in Google Sheets.

Sorts a range of data based on one or more columns in Google Sheets.

Sorts a range and returns the top N rows in Google Sheets.

Returns unique rows or values from a range in Google Sheets.

Creates a miniature chart within a single cell in Google Sheets.

Extracts text from a string that matches a regular expression in Google Sheets.

Checks if a text string matches a regular expression in Google Sheets, returning TRUE or FALSE.

Replaces text in a string that matches a regular expression with new text in Google Sheets.

Translates text from one language to another using Google Translate in Google Sheets.

Embeds an image from a URL into a cell in Google Sheets.

Creates a clickable link with custom text in Google Sheets.

Encodes a text string into a URL-safe format in Google Sheets.

Returns a number corresponding to an error type in Google Sheets.

Checks if a cell is empty in Google Sheets, returning TRUE or FALSE.

Checks if a value is an error other than #N/A in Google Sheets, returning TRUE or FALSE.

Checks if a value is any error in Google Sheets, returning TRUE or FALSE.

Checks if a number is even in Google Sheets, returning TRUE or FALSE.

Checks if a cell contains a formula in Google Sheets, returning TRUE or FALSE.

Checks if a value is a logical value (TRUE or FALSE) in Google Sheets.

Checks if a value is the #N/A error in Google Sheets, returning TRUE or FALSE.

Checks if a value is not text in Google Sheets, returning TRUE or FALSE.

Checks if a value is a number in Google Sheets, returning TRUE or FALSE.

Checks if a number is odd in Google Sheets, returning TRUE or FALSE.

Checks if a value is a valid cell reference in Google Sheets, returning TRUE or FALSE.

Checks if a value is text in Google Sheets, returning TRUE or FALSE.

Converts a value to a number in Google Sheets, with specific rules for different types.

Returns the #N/A error value in Google Sheets.

Returns a number indicating the data type of a value in Google Sheets.

Converts a binary number to decimal in Google Sheets.

Converts a binary number to hexadecimal in Google Sheets.

Converts a binary number to octal in Google Sheets.

Creates a complex number from real and imaginary parts in Google Sheets.

Converts a number from one unit to another in Google Sheets.

Converts a decimal number to binary in Google Sheets.

Converts a decimal number to hexadecimal in Google Sheets.

Converts a decimal number to octal in Google Sheets.

Converts a hexadecimal number to binary in Google Sheets.

Converts a hexadecimal number to decimal in Google Sheets.

Converts a hexadecimal number to octal in Google Sheets.

Returns the absolute value (modulus) of a complex number in Google Sheets.

Extracts the imaginary coefficient of a complex number in Google Sheets.

Returns the argument (angle in radians) of a complex number in Google Sheets.

Returns the complex conjugate of a complex number in Google Sheets.

Divides one complex number by another in Google Sheets.

Returns the exponential of a complex number in Google Sheets.

Returns the natural logarithm of a complex number in Google Sheets.

Returns the base-10 logarithm of a complex number in Google Sheets.

Returns the base-2 logarithm of a complex number in Google Sheets.

Raises a complex number to a specified power in Google Sheets.

Multiplies a series of complex numbers in Google Sheets.

Extracts the real coefficient of a complex number in Google Sheets.

Returns the sine of a complex number in Google Sheets.

Returns the square root of a complex number in Google Sheets.

Subtracts one complex number from another in Google Sheets.

Returns the tangent of a complex number in Google Sheets.

Converts an octal number to binary in Google Sheets.

Converts an octal number to decimal in Google Sheets.

Converts an octal number to hexadecimal in Google Sheets.

Calculates the average of a column in a database range based on criteria in Google Sheets.

Counts numeric values in a column of a database range based on criteria in Google Sheets.

Counts non-empty cells in a column of a database range based on criteria in Google Sheets.

Extracts a single value from a column in a database range based on criteria in Google Sheets.

Finds the maximum value in a column of a database range based on criteria in Google Sheets.

Finds the minimum value in a column of a database range based on criteria in Google Sheets.

Sums a column in a database range based on criteria in Google Sheets.