N Function in Google Sheets

Convert a value to a number using the N function.

N Function

The N function in Google Sheets is used to convert a value to a number.

Syntax

N(value)
  • value: The value you want to convert. This is a required parameter.

Example

  1. Convert TRUE to Number

Convert the logical value TRUE to a number:

=N(TRUE)

This will return 1.

Notes

  • Text values are converted to 0.
  • Logical values TRUE and FALSE are converted to 1 and 0, respectively.
  • Useful for ensuring numeric output in formulas.
  • VALUE: Convert a text string that looks like a number into a number.
  • TEXT: Convert a number into text format.