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.
- All versions
The value you want converted
- 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
If argument is an error, it returns the same error.
The function returns 0 if argument refers an empty cell.