Skip to content
Google Sheets

N function in Google Sheets

Returns the argument provided as a number.

=N(value)

N syntax and parameters

One argument, one required.

  • valueanyRequired

    The argument to be converted to a number. If value is TRUE, N returns 1. If value is a number, the number is returned. If value is a date or time, N returns a generated serial number, based on the number of days since December 30, 1899. Negative values are interpreted as days before this date, and fractional values indicate time of day past midnight. If value is FALSE or any value not listed above, N returns 0.

N examples

Formulas you'll actually reuse.

  1. A date as its serial number; text becomes 0, TRUE becomes 1:

    =N(D2)

    Result46248

  2. An inline comment — N of text is 0, so the sum is unchanged:

    =SUM(C2:C200) + N("Total after the Q3 refunds")

    Result148200

N in Excel

Same name — your formula ports as-is.

Try N in the playground

Edit the example — nothing to install.

Preloaded with the N formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Google Sheets gets this done.