ADD
ADD(value1, value2)
Returns the sum of two numbers. Equivalent to the `+` operator. Learn more
Produttivita
Apri schedaFormula reference avanzata
Cerca per funzione o sintassi, filtra i casi d’uso e passa direttamente agli strumenti operativi senza onboarding.
Digita almeno 2 lettere per vedere i suggerimenti.
17 formule trovate
Non sai da dove partire?
Percorsi per livello e use case
Base
Intermedio
Avanzato
Use case
Sfida del giorno
CONCAT
CONCAT(value1, value2)
Returns the concatenation of two values. Equivalent to the `&` operator. Learn more
Produttivita
Apri schedaDIVIDE
DIVIDE(dividend, divisor)
Returns one number divided by another. Equivalent to the `/` operator. Learn more
Produttivita
Apri schedaEQ
EQ(value1, value2)
Returns `TRUE` if two specified values are equal and `FALSE` otherwise. Equivalent to the `=` operator. Learn more
Produttivita
Apri schedaGT
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 schedaGTE
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 schedaISBETWEEN
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 schedaLT
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 schedaLTE
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 schedaMINUS
MINUS(value1, value2)
Returns the difference of two numbers. Equivalent to the `-` operator. Learn more
Produttivita
Apri schedaMULTIPLY
MULTIPLY(factor1, factor2)
Returns the product of two numbers. Equivalent to the `*` operator. Learn more
Produttivita
Apri schedaNE
NE(value1, value2)
Returns `TRUE` if two specified values are not equal and `FALSE` otherwise. Equivalent to the `<>` operator. Learn more
Produttivita
Apri schedaPOW
POW(base, exponent)
Returns a number raised to a power. Learn more
Produttivita
Apri schedaUMINUS
UMINUS(value)
Returns a number with the sign reversed. Learn more
Produttivita
Apri schedaUNARY_PERCENT
UNARY_PERCENT(percentage)
Returns a value interpreted as a percentage; that is, `UNARY_PERCENT(100)` equals `1`. Learn more
Produttivita
Apri schedaUNIQUE
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
Marketing Analisi dati
Apri schedaUPLUS
UPLUS(value)
Returns a specified number, unchanged. Learn more
Produttivita
Apri scheda