# Documentation/Calc Functions/N

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## Function name:

N

## Category:

Information

## Summary:

Returns the numeric value of the given parameter.

## Syntax:

N(**Value**)

## Returns:

Returns 0 if parameter is text, FALSE or an empty cell.

If an error occurs the function returns the error value.

## Arguments:

**Value** is the parameter to be converted into a number. N() returns the numeric value if it can. It returns the logical values TRUE and FALSE as 1 and 0 respectively. It returns text and an empty cell as 0.

## Additional details:

## Examples:

=N(123) returns 123

=N(5%) returns 0.05

=N(TRUE()) returns 1

=N(FALSE()) returns 0

=N("abc") returns 0

=N("123") returns 0

=N(A1) returns 0 where A1 is an empty cell

=N(1/0) returns #DIV/0!

=N(A1) returns 1.5 where A1 contains $1.50

=N(A1) returns 1500 where A1 contains 1.50E+03

=N(A1) returns 1.5 where A1 contains 1 1/2

=N(A1) returns 44291.44 where A1 contains the date and time 2021-04-05 10:30:00

=N(A1) returns 0 where A1 has the text format and contains 123

=N(A1) returns 0 where A1 contains '123

=N(NA()) returns #N/A