Skip to content

Data Empower – The Data Matrix

Search for:
Log in

Menu

Close
  • Home
  • Shop
  • Excel
    • All Excel Functions List
  • PowerBI
  • SQL
  • Fabric
  • Google sheets
    • Google Sheets All functions alphabetical
  • About
  • Home
  • Shop
  • Excel
    • All Excel Functions List
  • PowerBI
  • SQL
  • Fabric
  • Google sheets
    • Google Sheets All functions alphabetical
  • About
Search for:
Log in

Tag: error handling

  • Home
  • error handling
Xl information

ISERROR Excel function

Written by Data Empower May 22, 2025

Returns TRUE if the provided value corresponds to any error type.

XL Logical

IFNA Excel function

Written by Data Empower May 22, 2025

Returns the value you specify when the expression results in #N/A; otherwise, it yields the expression’s result.

Google sheets logical

IFNA Google Sheets function

Written by Data Empower May 19, 2025

Assesses a given value, returning a defined result if that value is an #N/A error.

Google sheets logical

IFERROR Google Sheets function

Written by Data Empower May 19, 2025

Returns the first argument when it is not an error; otherwise, it yields the second argument if provided, or a blank if the second is not available.

Google sheets info

ISERROR Google Sheets function

Written by Data Empower May 18, 2025

Determines if a given value represents an error.

Google sheets info

ISERR Google Sheets function

Written by Data Empower May 18, 2025

Determines if a value is any error type except for `#N/A`.

Google sheets info

ERROR.TYPE Google Sheets function

Written by Data Empower May 18, 2025

Returns a numerical representation corresponding to the error type found in a specified cell.

Follow me on Ganjing World!

Get the SQLBits T-Shirt now!

Copyright © 2025 Data Empower - The Data Matrix | Powered by BuddyX WordPress Theme