Author: Oscar Cronquist Article last updated on April 19, 2018

The N function returns a value converted into a number.

Formula in cell C3:


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

Excel Function Syntax



value Required. The value you want to convert.


This function is provided for compatibility with other software.