TO_PERCENT
Reads a number as a percentage.
- Excel: No equivalent
- Google Sheets: Not checked yet
- Returns: Number
Examples
=TO_PERCENT(0.25) Result 0.25
Syntax
TO_PERCENT(value) value- number required
Errors
#VALUE!=TO_PERCENT("alpha")
Related
FROMBYTESConverts byte array to integer. GENERATEIDGenerates unique ID with prefix and random suffix. HASHHex digest of text: SHA256 (default, FIPS 180-4) or MD5 (RFC 1321). IMAGEShows an image from a url: the browser loads it, the engine does not fetch. ISINChecks if value is in a range or comma-separated list. RANDOMCHOICERandom pick from a range (with replacement); count > 1 spills a column.