ISOMITTED Function in Excel: Was an Optional Argument Left Out?
LogicalLevel: ExpertAvailable in: Excel 365 / 2021+ISOMITTED is used inside LAMBDA to give optional parameters default.
Read article →Information
Excel Information functions explained with syntax, examples and common mistakes.
📊
← Excel
Information
Excel Information functions explained with syntax, examples and common mistakes.
📄 21 articles⬇️ 21 with practice files🕒 Updated 13 Oct 2026
🎓 Start here: Excel for India Course → 🎓 Start here: Excel Course: Beginner → Expert → 🎓 Start here: Bank Statement Automation →N Function in Excel: Turn a Value Into a Number
N Function in Excel: Turn a Value Into a Number
N returns numbers unchanged, TRUE as 1 and text as 0. Its oddest use is hiding a note inside a formula.
Read article →ISNONTEXT Function in Excel: Anything But Text
ISNONTEXT Function in Excel: Anything But Text
ISNONTEXT is TRUE for numbers, blanks, errors and logicals. Handy in data validation to block text in amount columns.
Read article →TYPE Function in Excel: What Kind of Value Is This?
TYPE Function in Excel: What Kind of Value Is This?
InformationLevel: IntermediateAvailable in: Excel 2007+TYPE returns 1 number, 2 text, 4 logical, 16 error or 64 array.Syntax=TYPE(value)ArgumentWhat it.
Read article →ISTEXT Function in Excel: Is It Text?
ISTEXT Function in Excel: Is It Text?
ISTEXT returns TRUE for text — the quickest way to find numbers or dates that were imported as text.
Read article →ISLOGICAL Function in Excel: Is It TRUE or FALSE?
ISLOGICAL Function in Excel: Is It TRUE or FALSE?
ISLOGICAL checks whether a value is a real TRUE/FALSE. Imports often bring the text "TRUE", which looks identical but is not.
Read article →ISNUMBER Function in Excel: Is It a Real Number?
ISNUMBER Function in Excel: Is It a Real Number?
ISNUMBER returns TRUE for numbers (and dates). Combined with SEARCH or MATCH, it turns “found / not found” into TRUE/FALSE.
Read article →ISFORMULA Function in Excel: Does the Cell Hold a Formula?
ISFORMULA Function in Excel: Does the Cell Hold a Formula?
ISFORMULA returns TRUE when a cell contains a formula. Use it in conditional formatting to catch numbers someone typed over a formula column.
Read article →ISREF Function in Excel: Is It a Valid Reference?
ISREF Function in Excel: Is It a Valid Reference?
ISREF returns TRUE when its argument is a reference. With INDIRECT it checks whether a sheet name typed by a user exists.
Read article →ERROR.TYPE Function in Excel: Which Error Is It?
ERROR.TYPE Function in Excel: Which Error Is It?
ERROR.TYPE returns a number for each error (1 #NULL!, 2 #DIV/0!, 3 #VALUE!, 4 #REF!, 5 #NAME?, 6 #NUM!, 7 #N/A) so you can…
Read article →ISNA Function in Excel: Is It “Not Found”?
ISNA Function in Excel: Is It “Not Found”?
ISNA returns TRUE only for #N/A — the “not found” result — so you can react to missing lookups specifically.
Read article →ISERR Function in Excel: Any Error Except #N/A
ISERR Function in Excel: Any Error Except #N/A
ISERR is TRUE for every error except #N/A. That lets you treat “not found” as normal while still catching real breakages like #DIV/0! or…
Read article →