Difference between revisions of "Manuals/calci/TONUMBER"
Jump to navigation
Jump to search
| Line 5: | Line 5: | ||
*This function converts a string to a number. | *This function converts a string to a number. | ||
*In <math> TONUMBER (Number)</math>,<math>Number</math> is any type number. | *In <math> TONUMBER (Number)</math>,<math>Number</math> is any type number. | ||
| + | *Here we have mention the parameter with in double quotes.For Example TONUMBER("2020") | ||
*Given number can be of any type like Positive Integer,Negative Integer and Decimal. | *Given number can be of any type like Positive Integer,Negative Integer and Decimal. | ||
*This function will give the result as "0" when the given value is Non Numeric. | *This function will give the result as "0" when the given value is Non Numeric. | ||
Latest revision as of 04:59, 19 February 2020
TONUMBER ("Number")
- is any number.
is any number.Description
- This function converts a string to a number.
- In , is any type number.
- Here we have mention the parameter with in double quotes.For Example TONUMBER("2020")
- Given number can be of any type like Positive Integer,Negative Integer and Decimal.
- This function will give the result as "0" when the given value is Non Numeric.
,Examples
- TONUMBER("34") = 34
- TONUMBER("12.3") = 12.3
- TONUMBER("-10") = -10