Manuals/calci/N

N(Number)

• $Number$ is the value.

Description

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

 value                              N returns(Result)
A number                         -     The Same number
Any date in DATE function format -     The Serial number of that date
TRUE                             -     1
FALSE                            -     0
An error value                   -     Error value
Anything else                    -     0

ZOS Section

• The syntax is to converting in to a number in ZOS is $N(Number)$
  • $Number$ is the value.
• For e.g.,N(29/5/2014),N(15*4+10-2/12)

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