IFERROR function

Syntax

Square brackets indicate optional arguments.

Arguments

Practice a complete task

• Count distinct values and show the list →

  See which customer names are distinct, exclude blank rows, and count the resulting list.

• Convert imported text into numbers →

  Convert amounts with an explicit decimal convention, keep missing values blank, and flag text that cannot be parsed.

• Average the records that qualify →

  Choose the intended region and delivery state, keep real zeros, and distinguish missing measurements from observations.

• Build an operational review with the right denominator →

  Compare two legitimate averages for one selected population and base the review flag on the agreed case-weighted metric.

• Convert fixed-width local date and time text →

  Build a real numeric timestamp from explicit components, then reject values that normalize to a different date or clock time.

• Classify real errors without misreading text →

  Return a category and classic error code for each imported value while preserving source order.

• Compare mean populations without changing stored types →

  Keep numeric zeroes, excluded text and explicit mean denominators visible before choosing an averaging rule.

• Compare formula operators and their evaluation order →

  Compare all four operator classes on real inputs: numeric order, Boolean comparisons, text joining and range/union/intersection references, plus an actual spill helper and row-dependent implicit intersection.

Reference and compatibility

• Microsoft function documentation ↗

Univer 1.0.4 / Apache-2.0. Calculation checks cover the supplied examples only. The browser worksheet does not implement every Excel feature, external service or connected data type.