AND
AND(logical_expression1, [logical_expression2, ...])
Returns true if all of the provided arguments are logically true, and false if any of the provided arguments are logically false. 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.
13 formule trovate
Non sai da dove partire?
Percorsi per livello e use case
Base
Intermedio
Avanzato
Use case
Sfida del giorno
FALSE
FALSE()
Returns the logical value `FALSE`. Learn more
Produttivita
Apri schedaIF
IF(logical_expression, value_if_true, value_if_false)
Returns one value if a logical expression is `TRUE` and another if it is `FALSE`. Learn more
Produttivita
Apri schedaIFERROR
IFERROR(value, [value_if_error])
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. Learn more
Produttivita
Apri schedaIFNA
IFNA(value, value_if_na)
Evaluates a value. If the value is an #N/A error, returns the specified value. Learn more.
Produttivita
Apri schedaIFS
IFS(condition1, value1, [condition2, value2], …)
Evaluates multiple conditions and returns a value that corresponds to the first true condition. Learn more.
Produttivita
Apri schedaLAMBDA
LAMBDA(name, formula_expression)
Creates and returns a custom function with a set of names and a formula_expression that uses them. To calculate the formula_expression, you can call the returned function with as many values as the name declares. Learn more
Produttivita
Apri schedaLET
LET(name1, value_expression1, [name2, …], [value_expression2, …], formula_expression )
Assigns name with the value_expression results and returns the result of the formula_expression. The formula_expression can use the names defined in the scope of the LET function. The value_expressions are evaluated only once in the LET function even if the following value_expressions or the formula_expression use them multiple times. Learn more
Produttivita
Apri schedaNOT
NOT(logical_expression)
Returns the opposite of a logical value - `NOT(TRUE)` returns `FALSE`; `NOT(FALSE)` returns `TRUE`. Learn more
Produttivita
Apri schedaOR
OR(logical_expression1, [logical_expression2, ...])
Returns true if any of the provided arguments are logically true, and false if all of the provided arguments are logically false. Learn more
Produttivita
Apri schedaSWITCH
SWITCH(expression, case1, value1, [default or case2, value2], …)
Tests an expression against a list of cases and returns the corresponding value of the first matching case, with an optional default value if nothing else is met. Learn more
Produttivita
Apri schedaTRUE
TRUE()
Returns the logical value `TRUE`. Learn more
Produttivita
Apri schedaXOR
XOR(logical_expression1, [logical_expression2, ...])
The XOR function performs an exclusive or of 2 numbers that returns a 1 if the numbers are different, and a 0 otherwise. Learn more.
Produttivita
Apri scheda