Difference between revisions of "Manuals/calci/N"
Jump to navigation
Jump to search
| Line 15: | Line 15: | ||
==Examples== | ==Examples== | ||
| − | #N(100)=100 | + | #=N(100) = 100 |
| − | #N(-154)=-154 | + | #=N(-154) = -154 |
| − | #N(2/1/1987)=0.001006543 | + | #=N(2/1/1987) = 0.001006543 |
| − | #N(TRUE)=1 | + | #=N(TRUE) = 1 |
| − | #N(FALSE)=0 | + | #=N(FALSE) = 0 |
| − | #N(2/0)=Infinity | + | #=N(2/0) = Infinity |
| − | #N("10/4")=0 | + | #=N("10/4") = 0 |
==See Also== | ==See Also== | ||
Revision as of 04:25, 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