How do I use the N function?

To use N, type =N( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.

Why is N not working in my Excel?

Common issues with N include Returns 0 for text. Start by checking the syntax =N(value), then verify each referenced cell or range.

Information

N Function in Excel

Returns a value converted to a number.

Syntax

=N(value)

Arguments

value (required): Value to convert

Examples

=N(TRUE) - Convert TRUE to number - Result: 1
=N("text") - Convert text to number - Result: 0

Defensive formulas with N

Use IS* functions inside IF to branch on blank, error, text, or number cells.
Prefer [IFERROR](/functions/iferror/) when you only need a fallback display value.
Error hub: [Fix formula errors](/guides/fix-excel-formula-errors/).

Common errors

Returns 0 for text

Use cases

Type conversion
Compatibility
Legacy formulas

Frequently asked questions

What is the N function in Excel? N returns a value converted to a number. The syntax is =N(value). Typical use cases include type conversion, compatibility, legacy formulas.
How do I use the N function? To use N, type =N( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.
Why is N not working in my Excel? Common issues with N include Returns 0 for text. Start by checking the syntax =N(value), then verify each referenced cell or range.

Editorial review

Reviewed by Excel.Directory Editorial Team. Updated May 2026.

When to use N

Type conversion — common Information scenario for N.
Compatibility — common Information scenario for N.
Legacy formulas — common Information scenario for N.

N in the Information category

Browse all Information functions at /categories/information/ for related formulas.
N syntax: =N(value)
value (required): Value to convert
Confirm N arguments match the syntax shown above before filling down.
Lock table and range references with $ when copying formulas across rows or sheets.

Formula checklist before you copy down

Confirm N arguments match the syntax shown above before filling down.
Lock table and range references with $ when copying formulas across rows or sheets.
If results look wrong, check for text stored as numbers and invisible spaces with TRIM.
Spot-check three known input rows manually against expected output.

Related Excel functions

VALUE (/functions/value/): Converts a text string that represents a number to a number.
T (/functions/t/): Returns the text referred to by value.
TYPE (/functions/type/): Returns a number indicating the data type of a value.

Errors to watch for

Returns 0 for text — review causes on linked error pages in the directory.

Copy-paste audit workflow

Enter N on three test rows with known expected output documented on a QA tab.
Fill down only after absolute references are locked on lookup tables and rate tables.
Compare against manual calculation or a calculator for financial and statistical functions.
Search this directory for comparison guides when choosing between similar functions in the same category.

N worked examples to copy

=N(TRUE) — Convert TRUE to number. Expected result: 1.
=N("text") — Convert text to number. Expected result: 0.

N reference summary for crawlers and offline review

N belongs to the Information category in Excel. Returns a value converted to a number.
Full syntax: =N(value). Open /functions/n/ for parameters, FAQs, and related pages.
Common mistakes: Returns 0 for text
Pair this function with comparison guides when another Excel formula might fit the same task better.
Review fix-excel-formula-errors when unexpected errors appear after upgrading Excel or sharing across locales.