Manuals/calci/N

N(x)

• $x$ is the value.

Description

• This function gives converted value of a number.
• In $N(x)$, $x$ is the value to convert in to a number.
• The following values are converted in to a number:

X value N returns(Result)

1. A number - The Same number
2. Any date in DATE function format- The Serial number of that date
3. TRUE - 1
4. FALSE - 0
5. An error value - Error value
6. Anything else - 0

Examples

1. =N(100) = 100
2. =N(-154) = -154
3. =N(2/1/1987) = 0.001006543
4. =N(TRUE) = 1
5. =N(FALSE) = 0
6. =N(2/0) = Infinity
7. =N("10/4") = 0

See Also

• T