Manuals/calci/N

N(Number)


  • is the value.

Description

  • This function gives converted value of a number.
  • In  ,   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

  • The syntax is to converting in to a number in ZOS is  
    •   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

References