Functions
N
Convert value to number
Try it
When to use it
When should I use N?
Use N to coerce a value to its numeric equivalent — it converts TRUE to 1, FALSE to 0, numbers unchanged, and text or errors to 0, which is handy when feeding logical results into arithmetic.
Used in
Syntax
N(value)Examples
=N(42) // => 42
=N(TRUE) // => 1
=N(FALSE) // => 0