This article helps you learn about how to use formulas and add functions in Sheets.

# Add formulas

Formulas are only available on the desktop version.

1. Type an **equal sign ****=**** **in the cell and then enter the **function name** directly.

2. A function list will show up giving the definition of a function and its syntax.

# List of Sheets functions

You can perform many calculation types by using functions to create formulas in Sheets. Below is the list of all available functions.

Function |
Definition |

ABS |
Returns the absolute value of a number. The absolute value of a number is the number without its sign. |

ACOSH |
Returns the inverse hyperbolic cosine of a number. |

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

AVERAGE |
Returns the numerical average value in a dataset, ignoring text. |

COMBIN |
Returns the number of ways to choose some number of objects from a pool of a given size of objects. |

CONCAT |
Returns the concatenation of two values. Equivalent to the `&` operator. |

CONCATENATE |
Appends strings to one another. |

CONVERT |
Converts a numeric value to a different unit of measure. |

COUNT |
Returns the number of numeric values in a dataset. |

COUNTA |
Returns the number of values in a dataset. |

COUNTIF |
Returns a conditional count across a range. |

DATE |
Converts a provided year, month, and day into a date. |

EXACT |
Tests whether two strings are identical. |

EXP |
Returns Euler's number, e (~2.718) raised to a power. |

FIND |
Returns the position at which a string is first found within text where the capitalization of letters matters. Returns #VALUE! if the string is not found. |

SEARCH |
Returns the position at which a string is first found within text and ignores capitalization of letters. Returns #VALUE! if the string is not found. |

SMALL |
Returns the nth smallest element from a data set, where n is user-defined. |

FLOOR.PRECISE |
Rounds a number down to the nearest integer multiple of specified significance. If the number is positive or negative, it is rounded down. |

FLOOR |
Rounds a number down to the nearest integer multiple of specified significance factor. |

IF |
Returns one value if a logical expression is TRUE and another if it is FALSE. |

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

IFNA |
Returns the value you specify if the formula returns the #N/A error value; otherwise returns the result of the formula. |

IFS |
Evaluates multiple conditions and returns a value that corresponds to the first true condition. |

IMSUB |
Returns the difference of two complex numbers in x + yi or x + yj text format. |

IMSUM |
Returns the sum of a series of complex numbers. |

INTERCEPT |
Calculates the y-value at which the line resulting from linear regression of a dataset will intersect the y-axis (x=0). |

LARGE |
Returns the nth largest element from a data set, where n is user-defined. |

ISNUMBER |
Checks whether a value is a number. |

ISBLANK |
Checks whether the referenced cell is empty. |

ISERROR |
Checks whether a value is an error. |

ISLOGICAL |
Checks whether a value is TRUE or FALSE. |

ISTEXT |
Checks whether a value is text. |

ISNONTEXT |
Checks whether a value is non-textual. |

ISREF |
Checks whether a value is a valid cell reference. |

ISEVEN |
Checks whether the provided value is even. |

ISODD |
Checks whether the provided value is odd. |

LEN |
Returns the length of a string. |

LOG |
Returns the logarithm of a number with respect to a base. |

LOWER |
Converts a specified string to lowercase. |

MAX |
Returns the maximum value in a numeric dataset. |

MID |
Returns a segment of a string. |

MIN |
Returns the minimum value in a numeric dataset. |

MOD |
Returns the result of the modulo operator, the remainder after a division operation. |

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

REPLACE |
Replaces part of a text string with a different text string. |

POWER |
Returns a number raised to a power. |

PERCENTILE |
Returns the value at a given percentile of a dataset. |

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

PRODUCT |
Returns the result of multiplying a series of numbers together. |

ROUND |
Rounds a number to a certain number of decimal places according to standard rules. |

ROUNDDOWN |
Rounds a number to a certain number of decimal places, always rounding down to the next valid increment. |

ROUNDUP |
Rounds a number to a certain number of decimal places, always rounding up to the next valid increment. |

CEILING |
Rounds a number up to the nearest integer multiple of specified significance factor. |

SQRT |
Returns the positive square root of a positive number. |

SUBSTITUTE |
Replaces existing text with new text in a string. |

SUM |
Returns the sum of a series of numbers and/or cells. |

SUMIF |
Returns a conditional sum across a range. |

TEXTJOIN |
Combines the text from multiple strings and/or arrays, with a specifiable delimiter separating the different texts. |

UPPER |
Converts a specified string to uppercase. |

VALUE |
Converts a string in any of the date, time or number formats that Google Sheets understands into a number. |

VAR |
Calculates the variance based on a sample. |

VARP |
Calculates the variance based on an entire population. |

STDEV |
Calculates the standard deviation based on a sample. |

STDEVP |
Calculates the standard deviation based on an entire population. |

COVAR |
Calculates the covariance of a dataset. |

WEEKDAY |
Returns a number representing the day of the week of the date provided. |

QUOTIENT |
Returns one number divided by another. |

LEFT |
Returns a substring from the beginning of a specified string. |

INT |
Rounds a number down to the nearest integer that is less than or equal to it. |

RIGHT |
Returns a substring from the end of a specified string. |

RANK |
Returns the rank of a specified value in a dataset. |

ACOS |
Returns the inverse cosine of a value, in radians. |

LN |
Returns the logarithm of a number, base e (Euler's number). |

AVERAGEA |
Returns the numerical average value in a dataset, ignoring text. |

MEDIAN |
Returns the median value in a numeric dataset. |

QUARTILE |
Returns a value nearest to a specified quartile of a dataset. |

RANDBETWEEN |
Returns a uniformly random integer between two values, inclusive. |

TRIM |
Removes leading, trailing, and repeated spaces in text. |

TRIMMEAN |
Calculates the mean of a dataset excluding some proportion of data from the high and low ends of the dataset. |

RAND |
Returns a random number between 0 inclusive and 1 exclusive. |

AVEDEV |
Calculates the average of the magnitudes of deviations of data from a dataset's mean. |

COUNTIFS |
The COUNTIFS function applies criteria to cells across multiple ranges and counts the number of times all criteria are met. |

INDEX |
Returns the reference of the cell at the intersection of a particular row and column. If the reference is made up of nonadjacent selections, you can pick the selection to look in. |

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

COUPDAYSNC |
Calculates the number of days from the settlement date until the next coupon, or interest payment. |

ROW |
Returns the row number of a specified cell. |

FORMULATEXT |
Returns a formula as a string. |

VLOOKUP |
Vertical lookup. Searches down the first column of a range for a key and returns the value of a specified cell in the row found. |

HLOOKUP |
Horizontal lookup. Searches across the first row of a range for a key and returns the value of a specified cell in the column found. |

DAY |
Returns the day of the month that a specific date falls on, in numeric format. |

MONTH |
Returns the month of the year a specific date falls in, in numeric format. |

YEAR |
Returns the year specified by a given date. |

DATEDIF |
Calculates the number of days, months, or years between two dates. |

DAYS |
Returns the number of days between two dates. |

DAYS360 |
Returns the difference between two days based on the 360 day year used in some financial interest calculations. |

SUMIFS |
Returns the sum of a range depending on multiple criteria. |

AVERAGEIF |
Returns the average of a range depending on criteria. |

AVERAGEIFS |
Returns the average of a range depending on multiple criteria. |

TODAY |
Returns the current date as a date value. |

NOW |
Returns the current date and time as a date value. |

OFFSET |
Returns a range reference shifted a specified number of rows and columns from a starting cell reference. |

SUMPRODUCT |
Calculates the sum of the products of corresponding entries in two equal-sized arrays or ranges. |

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

SUBTOTAL |
Returns a subtotal for a vertical range of cells using a specified aggregation function. |

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

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

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

ADDRESS |
Returns a cell reference as a string. |

INDIRECT |
Returns a cell reference specified by a string. |

LOOKUP |
Looks through a sorted row or column for a key and returns the value of the cell in a result range located in the same position as the search row or column. |

COUNTBLANK |
Returns the number of empty values in a list of values and ranges. |

ISFORMULA |
Checks whether a value is a formula. |

NETWORKDAYS |
Returns the number of net working days between two provided days. |

WEEKNUM |
Returns a number representing the week of the year where the provided date falls. |

CHOOSE |
Returns an element from a list of choices based on index. |