CELL
CELL(info_type, reference)
Returns the requested information about the specified cell. Learn more
Analisi dati
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.
18 formule trovate
Non sai da dove partire?
Percorsi per livello e use case
Base
Intermedio
Avanzato
Use case
Sfida del giorno
ERROR.TYPE
ERROR.TYPE(reference)
Returns a number corresponding to the error value in a different cell. Learn more
Analisi dati
Apri schedaISBLANK
ISBLANK(value)
Checks whether the referenced cell is empty. Learn more
Analisi dati
Apri schedaISDATE
ISDATE(value)
Returns whether a value is a date. Learn more.
Analisi dati
Apri schedaISEMAIL
ISEMAIL(value)
Checks whether a value is a valid email address. Learn more
Analisi dati
Apri schedaISERR
ISERR(value)
Checks whether a value is an error other than `#N/A`. Learn more
Analisi dati
Apri schedaISERROR
ISERROR(value)
Checks whether a value is an error. Learn more
Analisi dati
Apri schedaISFORMULA
ISFORMULA(cell)
Checks whether a formula is in the referenced cell. Learn more
Analisi dati
Apri schedaISLOGICAL
ISLOGICAL(value)
Checks whether a value is `TRUE` or `FALSE`. Learn more
Analisi dati
Apri schedaISNA
ISNA(value)
Checks whether a value is the error `#N/A`. Learn more
Analisi dati
Apri schedaISNONTEXT
ISNONTEXT(value)
Checks whether a value is non-textual. Learn more
Analisi dati
Apri schedaISNUMBER
ISNUMBER(value)
Checks whether a value is a number. Learn more
Analisi dati
Apri schedaISREF
ISREF(value)
Checks whether a value is a valid cell reference. Learn more
Analisi dati
Apri schedaISTEXT
ISTEXT(value)
Checks whether a value is text. Learn more
Analisi dati
Apri schedaN
N(value)
Returns the argument provided as a number. Learn more
Analisi dati
Apri schedaNA
NA()
Returns the "value not available" error, `#N/A`. Learn more
Analisi dati
Apri schedaSHEETS
SHEETS(reference)
Returns the total number of sheets in the referenced spreadsheet. Learn more about the SHEETS function.
Analisi dati
Apri schedaTYPE
TYPE(value)
Returns a number associated with the type of data passed into the function. Learn more
Analisi dati
Apri scheda