Difference between revisions of "Manuals/calci/PARSENUMBER"
Jump to navigation
Jump to search
(Created page with "<div style="font-size:30px">'''PARSENUMBER (OriginalNumber)'''</div><br/> *<math>OriginalNumber</math> is any number. ==Description== *This function gives an information obje...") |
|||
| Line 21: | Line 21: | ||
"sign": 1 | "sign": 1 | ||
} | } | ||
| + | #PARSENUMBER(-99.7) | ||
| + | { | ||
| + | "digits": 2, | ||
| + | "decimals": 2, | ||
| + | "exponent": 1, | ||
| + | "sign": -1 | ||
| + | } | ||
| + | |||
| + | ==See Also== | ||
| + | *[[Manuals/calci/DIGITS| DIGITS]] | ||
| + | *[[Manuals/calci/DECIMAL | DECIMAL ]] | ||
| + | *[[Manuals/calci/SIGN | SIGN]] | ||
| + | *[[Manuals/calci/PERCENTRANK | PERCENTRANK ]] | ||
| + | |||
| + | ==References== | ||
Revision as of 00:51, 25 February 2020
PARSENUMBER (OriginalNumber)
- is any number.
is any number.Description
- This function gives an information object with digits, decimals, exponent and sign.
- A digit is a single symbol used to make numerals.0, 1, 2, 3, 4, 5, 6, 7, 8 and 9 are the ten digits we use in everyday numerals.
- A decimal is a number expressed in the scale of tens.A decimal point is a point or dot used to separate the whole part of a number from the fractional part of a number.
- The exponent of a number says how many times to use the number in a multiplication.
- Sign of the number is if the number is positive then it will give the result as 1.
- If the number is negative then the result of the sign is -1.
- In , can be any number.
- The number can be positive,negative,integer,fraction or decimals.
- This function will give the result as error when the Original number is Non Numeric.
,Examples
- PARSENUMBER("34.54")
{
"digits": 2, "decimals": 3, "exponent": 1, "sign": 1
}
- PARSENUMBER(-99.7)
{
"digits": 2, "decimals": 2, "exponent": 1, "sign": -1
}