NA Function in Excel: Return #N/A on Purpose
NA produces #N/A deliberately. Charts skip #N/A points instead of plotting them as zero.
Read article →Information
Excel Information functions explained with syntax, examples and common mistakes.
INFO Function in Excel: About Your Excel Environment
INFO Function in Excel: About Your Excel Environment
INFO returns details like the Excel version, operating system or current folder.
Read article →SHEETS Function in Excel: How Many Sheets?
SHEETS Function in Excel: How Many Sheets?
SHEETS counts sheets in a reference or the whole workbook — including hidden ones.
Read article →ISODD Function in Excel: Is the Number Odd?
ISODD Function in Excel: Is the Number Odd?
InformationLevel: BeginnerAvailable in: Excel 2007+ISODD returns TRUE for odd numbers (decimals are truncated first).Syntax=ISODD(number)ArgumentWhat it.
Read article →ISERROR Function in Excel: Does the Formula Return Any Error?
ISERROR Function in Excel: Does the Formula Return Any Error?
ISERROR returns TRUE for any error value. It is mostly used in conditional formatting and checks; for replacing errors, IFERROR is simpler.
Read article →SHEET Function in Excel: Which Sheet Number?
SHEET Function in Excel: Which Sheet Number?
InformationLevel: IntermediateAvailable in: Excel 2013+SHEET returns the position number of a sheet.Syntax=SHEET([value])ArgumentWhat it meansvalueA.
Read article →CELL Function in Excel: Information About a Cell
CELL Function in Excel: Information About a Cell
CELL reports details such as address, column width, number format or file path. Its best-known use is getting the current sheet name.
Read article →ISEVEN Function in Excel: Is the Number Even?
ISEVEN Function in Excel: Is the Number Even?
ISEVEN returns TRUE for even numbers; ISODD for odd ones. Decimals are truncated first.
Read article →ISBLANK Function in Excel: Is the Cell Truly Empty?
ISBLANK Function in Excel: Is the Cell Truly Empty?
ISBLANK returns TRUE only for truly empty cells. A formula returning "" is not blank to ISBLANK — a common surprise.
Read article →