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.

Azzera

16 formule trovate

Non sai da dove partire? Percorsi per livello e use case
Base Intermedio Avanzato Use case Sfida del giorno
Operator Intermedio

ADD

ADD(value1, value2)

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

Produttivita

Apri scheda
Operator Intermedio

CONCAT

CONCAT(value1, value2)

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

Produttivita

Apri scheda
Operator Intermedio

DIVIDE

DIVIDE(dividend, divisor)

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

Produttivita

Apri scheda
Operator Intermedio

EQ

EQ(value1, value2)

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

Produttivita

Apri scheda
Operator Intermedio

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

Produttivita

Apri scheda
Operator Intermedio

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

Produttivita

Apri scheda
Operator Intermedio

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

Produttivita

Apri scheda
Operator Intermedio

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

Produttivita

Apri scheda
Operator Intermedio

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

Produttivita

Apri scheda
Operator Intermedio

MINUS

MINUS(value1, value2)

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

Produttivita

Apri scheda
Operator Intermedio

MULTIPLY

MULTIPLY(factor1, factor2)

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

Produttivita

Apri scheda
Operator Intermedio

NE

NE(value1, value2)

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

Produttivita

Apri scheda
Operator Intermedio

POW

POW(base, exponent)

Returns a number raised to a power. Learn more

Produttivita

Apri scheda
Operator Intermedio

UMINUS

UMINUS(value)

Returns a number with the sign reversed. Learn more

Produttivita

Apri scheda
Operator Intermedio

UNARY_PERCENT

UNARY_PERCENT(percentage)

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

Produttivita

Apri scheda
Operator Intermedio

UPLUS

UPLUS(value)

Returns a specified number, unchanged. Learn more

Produttivita

Apri scheda