Formualizer Docs
ReferenceFunctionsInformation Functions

N

Converts a value to its numeric representation.

Summary

Converts a value to its numeric representation.

Remarks

  • Numbers pass through unchanged; booleans convert to 1/0.
  • Text and blank values convert to 0.
  • Errors propagate unchanged.
  • Temporal values are converted using serial number representation.

Examples

Boolean to number
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
1
Text to zero
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
0

FAQ

What does N do with text and blanks?

Text and blank values convert to 0, while existing errors are passed through.

Runtime metadata

Category

Information

Signature

N(arg1: Any)

Arity

min 1, max 1

Arguments

arg1

Any · Scalar

Caps

PURE

Source

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

ISTEXT

ISTEXT: Returns TRUE when the value is text.

NA

NA: Returns the `#N/A` error value.

On this page

SummaryRemarksExamplesRelated functionsFAQWhat does N do with text and blanks?Runtime metadata