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