Manuals/calci/PARSENUMBER

Revision as of 00:53, 25 February 2020 by Devika (talk | contribs) (→‎See Also)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
PARSENUMBER (OriginalNumber)


  • 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

  1. PARSENUMBER("34.54")

{

   "digits": 2,
   "decimals": 3,
   "exponent": 1,
   "sign": 1

}

  1. PARSENUMBER(-99.7)

{

   "digits": 2,
   "decimals": 2,
   "exponent": 1,
   "sign": -1

}

See Also

References

Digits