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