PARSEPERCENTAGE function
TextualPercentage
The text string containing a percentage.
Returns
The number found in the given text string.
Interprets a text string as a percentage and returns it. PARSEPERCENTAGE("75%")PARSEPERCENTAGE("75%") returns 0.75.
PARSEPERCENTAGE takes the language of the app into account when converting text strings to numbers. When PARSEPERCENTAGE 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 PARSEPERCENTAGE 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 very flexible in terms of what input it can parse. For instance, PARSEPERCENTAGE("00350.050%")PARSEPERCENTAGE("00350.050%") returns 3.5005.
This function is specific to Calcapp.
Related functions
- Use FORMATPERCENTAGE 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 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 0.75.
Returns the array { 0.75, 2.33 }{ 0,75; 2,33 }.
Returns 3.5005.