Manuals/calci/N

Revision as of 02:19, 1 January 2014 by Devika (talk | contribs)
N(x)


  • is the value.


Description

  • This functon 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:

X value N returns(Result)

  1. A number - The Same number
  2. Any date in DATEfunction 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

References