Difference between revisions of "Manuals/calci/TONUMBER"
Jump to navigation
Jump to search
(One intermediate revision by the same user not shown) | |||
Line 4: | Line 4: | ||
==Description== | ==Description== | ||
*This function converts a string to a number. | *This function converts a string to a number. | ||
− | *In <math> TONUMBER ( | + | *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 03:59, 19 February 2020
TONUMBER ("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