PARSESCIENTIFIC function
TextualNumber
The text string containing a number using scientific notation.
Returns
The number found in the given text string.
Interprets a text string as a number and returns it, where said text string is expected to use scientific notation. PARSESCIENTIFIC("3.5005E+03")PARSESCIENTIFIC("3.5005E+03") (which should be interpreted as 3.5005 * 10^3) returns 3500.5. Scientific notation is an effective means of conveying very small or very large numbers.
PARSESCIENTIFIC takes the language of the app into account when converting text strings to numbers. When PARSESCIENTIFIC is used with an app whose language is set to German, for instance, text strings representing numbers should use a comma (",") as a decimal separator. When PARSESCIENTIFIC is used with an app whose language is set to UK English, a decimal point (".") should be used. Language-appropriate thousands separators may be used.
This function is specific to Calcapp.
Related functions
- Use FORMATSCIENTIFIC to create text strings that can be interpreted by this function.
- Use PARSENUMBER to parse a regular number (like "18.4").
- Use PARSEFRACTION to parse a fraction (like "3 3/4").
- Use PARSEPERCENTAGE to parse a percentage (like "75%").
- Use PARSESCIENTIFIC to parse numbers using scientific notation (like "1.5E+03").
- Use TONUMBER to convert text strings to numbers if you only need a limited feature set.
Examples
Returns 3500.5, if the decimal separator of the language the app is configured to use is a decimal point. If the decimal separator is a decimal comma, an error is returned.
Returns the array { 3500.5, 0.00035 }{ 3500,5; 0,00035 }, if the decimal separator of the language the app is configured to use is a decimal point. If the decimal separator is a decimal comma, an array of errors is returned.