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.

Google

ARRAYFORMULA

ARRAYFORMULA(array_formula)

Enables the display of values returned from an array formula into multiple rows and/or columns and the use of non-array functions with arrays. Learn more

Apri scheda
Google

DETECTLANGUAGE

DETECTLANGUAGE(text_or_range)

Identifies the language used in text within the specified range. Learn more

Apri scheda
Google

GOOGLEFINANCE

GOOGLEFINANCE(ticker, [attribute], [start_date], [end_date|num_days], [interval])

Fetches current or historical securities information from Google Finance. Learn more

Apri scheda
Google

GOOGLETRANSLATE

GOOGLETRANSLATE(text, [source_language], [target_language])

Translates text from one language into another Learn more

Apri scheda
Google

IMAGE

IMAGE(url, [mode], [height], [width])

Inserts an image into a cell. Learn more

Apri scheda
Google

QUERY

QUERY(data, query, [headers])

Runs a Google Visualization API Query Language query across data. Learn more

Apri scheda
Google

SPARKLINE

SPARKLINE(data, [options])

Creates a miniature chart contained within a single cell. Learn more

Apri scheda