ADD
ADD(value1, value2)
Returns the sum of two numbers. Equivalent to the `+` operator. Learn more
Apri schedaUna 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.
ADD(value1, value2)
Returns the sum of two numbers. Equivalent to the `+` operator. Learn more
Apri schedaCONCAT(value1, value2)
Returns the concatenation of two values. Equivalent to the `&` operator. Learn more
Apri schedaDIVIDE(dividend, divisor)
Returns one number divided by another. Equivalent to the `/` operator. Learn more
Apri schedaEQ(value1, value2)
Returns `TRUE` if two specified values are equal and `FALSE` otherwise. Equivalent to the `=` operator. Learn more
Apri schedaGT(value1, value2)
Returns `TRUE` if the first argument is strictly greater than the second, and `FALSE` otherwise. Equivalent to the `>` operator. Learn more
Apri schedaGTE(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 schedaISBETWEEN(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 schedaLT(value1, value2)
Returns `TRUE` if the first argument is strictly less than the second, and `FALSE` otherwise. Equivalent to the `<` operator. Learn more
Apri schedaLTE(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 schedaMINUS(value1, value2)
Returns the difference of two numbers. Equivalent to the `-` operator. Learn more
Apri schedaMULTIPLY(factor1, factor2)
Returns the product of two numbers. Equivalent to the `*` operator. Learn more
Apri schedaNE(value1, value2)
Returns `TRUE` if two specified values are not equal and `FALSE` otherwise. Equivalent to the `<>` operator. Learn more
Apri schedaPOW(base, exponent)
Returns a number raised to a power. Learn more
Apri schedaUMINUS(value)
Returns a number with the sign reversed. Learn more
Apri schedaUNARY_PERCENT(percentage)
Returns a value interpreted as a percentage; that is, `UNARY_PERCENT(100)` equals `1`. Learn more
Apri schedaUNIQUE(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 schedaUPLUS(value)
Returns a specified number, unchanged. Learn more
Apri scheda