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.

Info

CELL

CELL(info_type, reference)

Returns the requested information about the specified cell. Learn more

Apri scheda
Info

ERROR.TYPE

ERROR.TYPE(reference)

Returns a number corresponding to the error value in a different cell. Learn more

Apri scheda
Info

ISBLANK

ISBLANK(value)

Checks whether the referenced cell is empty. Learn more

Apri scheda
Info

ISDATE

ISDATE(value)

Returns whether a value is a date. Learn more. 

Apri scheda
Info

ISEMAIL

ISEMAIL(value)

Checks whether a value is a valid email address. Learn more

Apri scheda
Info

ISERR

ISERR(value)

Checks whether a value is an error other than `#N/A`. Learn more

Apri scheda
Info

ISFORMULA

ISFORMULA(cell)

Checks whether a formula is in the referenced cell. Learn more

Apri scheda
Info

ISLOGICAL

ISLOGICAL(value)

Checks whether a value is `TRUE` or `FALSE`. Learn more

Apri scheda
Info

ISNA

ISNA(value)

Checks whether a value is the error `#N/A`. Learn more

Apri scheda
Info

ISREF

ISREF(value)

Checks whether a value is a valid cell reference. Learn more

Apri scheda
Info

N

N(value)

Returns the argument provided as a number. Learn more

Apri scheda
Info

NA

NA()

Returns the "value not available" error, `#N/A`. Learn more

Apri scheda
Info

SHEETS

SHEETS(reference)

Returns the total number of sheets in the referenced spreadsheet. Learn more about the SHEETS function.

Apri scheda
Info

TYPE

TYPE(value)

Returns a number associated with the type of data passed into the function. Learn more

Apri scheda