Function: N

by | Jan 8, 2019 | Excel Formulas

N Function

The N function is an information function that returns a value converted to a number. In this guide, we’re going to show you how to use the N function and also throw in some tips and error handling methods.

Supported versions

  • All versions

Syntax

N(value)

Arguments

value The value you want converted


Examples

Example 1

=N(5)
formula returns 5. The numbers are not affected by the N function. On the other hand, the function converts strings to 0.

N-1

Example 2

=SUMPRODUCT(N({"A";"A";"A";"A";"A";"A";"A";"B";"B";"B"}="A"))
formula returns 7. The SUMPRODUCT function allows array operations and sums the one and zero values from the N function. It produces the following array before sum action: {1;1;1;1;1;1;1;0;0;0}

N-1

Download Workbook

Tips

Issues

Error

If argument is an error, it returns the same error.

Empty string

The function returns 0 if argument refers an empty cell.