Excel Information Functions Syntax List

Last modified date

Excel Information Functions Syntax List

Below the list of Information Functions, at bottom of the table links are provided to download this data in PDF and Excel Formats.

S.no.Function NameSyntax
1CELLCELL(info_type,[reference])
2ERROR.TYPEERROR.TYPE(error_val)
3INFOINFO(type_text)
4ISBLANKISBLANK(value)
5ISERRISERR(value)
6ISERRORISERROR(value)
7ISEVENISEVEN(number)
8ISFORMULAISFORMULA(reference)
9ISLOGICALISLOGICAL(value)
10ISNAISNA(value)
11ISNONTEXTISNONTEXT(value)
12ISNUMBERISNUMBER(value)
13ISODDISODD(number)
14ISREFISREF(value)
15ISTEXTISTEXT(value)
16NN(value)
17NANA()
18SHEETSHEET([value])
19SHEETSSHEETS([reference])
20TYPETYPE(value)

Click here to download the PDF of Excel Information Functions Syntax List

Click here to download the Workbook of Excel Information Functions Syntax List

Leave a Reply

Your email address will not be published. Required fields are marked *

Post comment