Formualizer Docs
ReferenceFunctionsInformation Functions

ERROR.TYPE

ERROR.TYPE: Returns a number corresponding to an error type Returns: 1 = #NULL! 2 = #DIV/0! 3 = #VALUE! 4 = #REF! 5 = #NAME? 6 = #NUM! 7 = #N/A 8 = #GETTING_DATA (n…

Summary

NOTE: Error codes 9-13 are non-standard extensions for internal error types.

Returns the numeric code for a specific error value.

Remarks

  • Standard mappings include: #NULL!=1, #DIV/0!=2, #VALUE!=3, #REF!=4, #NAME?=5, #NUM!=6, #N/A=7.
  • Non-error inputs return #N/A.
  • Additional internal error kinds may map to extended non-standard codes.

Examples

Map DIV/0 to code
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
2
Non-error input returns N/A
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
#N/A

FAQ

What if the input is not an error value?

ERROR.TYPE returns #N/A when the input is not an error.

Runtime metadata

Category

Information

Signature

ERROR.TYPE(arg1: Any)

Arity

min 1, max 1

Arguments

arg1

Any · Scalar

Caps

PURE

Source

crates/formualizer-eval/src/builtins/info.rs

Information Functions

Generated reference pages for Information functions.

ISBLANK

ISBLANK: Returns TRUE only for a truly empty value.

On this page

SummaryRemarksExamplesRelated functionsFAQWhat if the input is not an error value?Runtime metadata