Libreria formule

Funzioni Google Sheets

Una scheda strutturata per ogni funzione: sintassi, argomenti, esempi pratici, errori comuni, FAQ e collegamenti a formule correlate.

Digita almeno 2 lettere per vedere i suggerimenti.

Operator

ADD

ADD(value1, value2)

Returns the sum of two numbers. Equivalent to the `+` operator. Learn more

Apri scheda
Operator

CONCAT

CONCAT(value1, value2)

Returns the concatenation of two values. Equivalent to the `&` operator. Learn more

Apri scheda
Operator

DIVIDE

DIVIDE(dividend, divisor)

Returns one number divided by another. Equivalent to the `/` operator. Learn more

Apri scheda
Operator

EQ

EQ(value1, value2)

Returns `TRUE` if two specified values are equal and `FALSE` otherwise. Equivalent to the `=` operator. Learn more

Apri scheda
Operator

GT

GT(value1, value2)

Returns `TRUE` if the first argument is strictly greater than the second, and `FALSE` otherwise. Equivalent to the `>` operator. Learn more

Apri scheda
Operator

GTE

GTE(value1, value2)

Returns `TRUE` if the first argument is greater than or equal to the second, and `FALSE` otherwise. Equivalent to the `>=` operator. Learn more

Apri scheda
Operator

ISBETWEEN

ISBETWEEN(value_to_compare, lower_value, upper_value, lower_value_is_inclusive, upper_value_is_inclusive)

Checks whether a provided number is between two other numbers either inclusively or exclusively. Learn more

Apri scheda
Operator

LT

LT(value1, value2)

Returns `TRUE` if the first argument is strictly less than the second, and `FALSE` otherwise. Equivalent to the `<` operator. Learn more

Apri scheda
Operator

LTE

LTE(value1, value2)

Returns `TRUE` if the first argument is less than or equal to the second, and `FALSE` otherwise. Equivalent to the `<=` operator. Learn more

Apri scheda
Operator

MINUS

MINUS(value1, value2)

Returns the difference of two numbers. Equivalent to the `-` operator. Learn more

Apri scheda
Operator

MULTIPLY

MULTIPLY(factor1, factor2)

Returns the product of two numbers. Equivalent to the `*` operator. Learn more

Apri scheda
Operator

NE

NE(value1, value2)

Returns `TRUE` if two specified values are not equal and `FALSE` otherwise. Equivalent to the `<>` operator. Learn more

Apri scheda
Operator

POW

POW(base, exponent)

Returns a number raised to a power. Learn more

Apri scheda
Operator

UMINUS

UMINUS(value)

Returns a number with the sign reversed. Learn more

Apri scheda
Operator

UNARY_PERCENT

UNARY_PERCENT(percentage)

Returns a value interpreted as a percentage; that is, `UNARY_PERCENT(100)` equals `1`. Learn more

Apri scheda
Operator

UNIQUE

UNIQUE(range, by_column, exactly_once)

Returns unique rows in the provided source range, discarding duplicates. Rows are returned in the order in which they first appear in the source range. Learn more

Apri scheda
Operator

UPLUS

UPLUS(value)

Returns a specified number, unchanged. Learn more

Apri scheda