Difference between revisions of "Manuals/calci/N"
Jump to navigation
Jump to search
| Line 3: | Line 3: | ||
==Description== | ==Description== | ||
| − | *This | + | *This function gives converted value of a number. |
| − | *In <math> N(x),x</math> is the value to convert in to a number. | + | *In <math> N(x)</math>, <math>x</math> is the value to convert in to a number. |
*The following values are converted in to a number: | *The following values are converted in to a number: | ||
X value N returns(Result) | X value N returns(Result) | ||
#A number - The Same number | #A number - The Same number | ||
| − | #Any date in | + | #Any date in DATE function format- The Serial number of that date |
#TRUE - 1 | #TRUE - 1 | ||
#FALSE - 0 | #FALSE - 0 | ||
#An error value - Error value | #An error value - Error value | ||
| − | #Anything else - 0 | + | #Anything else - 0 |
==Examples== | ==Examples== | ||
Revision as of 04:23, 3 January 2014
N(x)
- is the value.
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:
, X 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
Examples
- N(100)=100
- N(-154)=-154
- N(2/1/1987)=0.001006543
- N(TRUE)=1
- N(FALSE)=0
- N(2/0)=Infinity
- N("10/4")=0