Information(Microsoft Excel Functions)

03/15/2024

Japanese version.

It primarily includes functions for examining the nature of the data in a cell. Functions other than error determination are used less frequently.

Functions.

FunctionImportanceDescription
ERROR.TYPE
ISERR
ISERROR
ISNA
HighPerforms cell error determination.
ISBLANK
ISFORMULA
ISREF
ISTEXT
ISNONTEXT
ISLOGICAL
ISNUMBER
ISODD
ISEVEN
MiddleDetermines what kind of information the data in the cell is.
CELLLowGet various information about the cell.
INFOLowGet information about the operating environment.
ISOMITTEDMiddleHelper function for LAMBDA functions to determine if custom function arguments are set or omitted.
NALowGenerate N/A error.
SHEETLowGet the number of the designated sheet.
SHEETSLowGet the number of worksheets.
TYPELowGet cell data type.