Information(Microsoft Excel Functions)

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. Function Importance Description ERROR.TYPEISERRISERRORISNA High Performs cell error determination. ISBLANKISFORMULAISREFISTEXTISNONTEXTISLOGICALISNUMBERISODDISEVEN Middle Determines what kind of information the data in the cell is. CELL Low Get various information about the cell. INFO Low Get information about the operating environment. ISOMITTED Middle Helper function for LAMBDA functions to determine if custom function arguments are set or omitted. NA Low Generate N/A error. SHEET Low Get the number of the designated sheet. SHEETS Low Get the number of worksheets. TYPE Low Get cell data type.