# Documentation/Calc Functions/N

From The Document Foundation Wiki

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 or FALSE.

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 as 0.

## Additional details:

## Examples:

=N(123) returns 123

=N(TRUE()) returns 1

=N(FALSE()) returns 0

=N("abc") returns 0

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