Modalità esperto · accesso rapido

Formula 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.

Azzera

2 formule trovate

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

LAMBDA

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 scheda
Logical Avanzato

LET

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 scheda