ISOMITTED

checks if lambda argument is omitted · from excel · excel: not yet compared · no sheets equivalent

signature

ISOMITTED(argument)

returns: boolean

argumentrequired
argument required

examples

formula and result, taken from the engine's own test suite — every result below is asserted in CI, not written by hand.

fx =LAMBDA(x, ISOMITTED(x))(1) false

related

  • ARRAY_CONSTRAIN truncates a range to at most the given rows and columns
  • ARRAYFORMULA evaluates an expression across a range (this engine already spills, so it is a pass-through for sheets compatibility)
  • ARRAYTOTEXT converts array to text representation
  • BYCOL applies lambda to each column of array
  • BYROW applies lambda to each row of array
  • CHOOSECOLS returns the specified columns from an array