N Function in Excel: Syntax, Examples and Free Practice
N is an Excel Information function. Converts a value to a number — text becomes 0, dates become serial numbers.
N syntax
=N(value)
Arguments
value: The value to evaluate
When to use N
N is used to check the state or type of a cell before other formulas act on it.
Practice N online, free
Open the live Excel-style spreadsheet and try N yourself. No Excel install or sign-up needed to start.
Practice N now →More Information functions
Frequently asked questions
What does the N function do in Excel?
Converts a value to a number — text becomes 0, dates become serial numbers.
What is the syntax of N in Excel?
The syntax is =N(value). value: The value to evaluate.
Where can I practice N online for free?
Open the free live spreadsheet on Cellgrids and try N yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Information functions · Excel case studies · Excel tutorials · Excel shortcuts