Article updated on April 19, 2018

The N function returns a value converted into a number.

Formula in cell C3:

=N(B3)

The N function returns the corresponding serial number for dates, 1 for TRUE and 0 (zero) for FALSE.

Excel Function Syntax

N(value)

Arguments

value Required. The value you want to convert.

Comments

This function is provided for compatibility with other software.