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)
Example 2
=SUMPRODUCT(N({"A";"A";"A";"A";"A";"A";"A";"B";"B";"B"}="A"))
Tips
- It acts like the double unary (--) operator which converts Boolean values to ones and zeroes. For more information, please visit What does double minus -- do in Excel
Issues
Error
If argument is an error, it returns the same error.
Empty string
The function returns 0 if argument refers an empty cell.