Functions
TO_PERCENT
Formats a number as a percentage
Try it
When to use it
When should I use TO_PERCENT?
Use TO_PERCENT to apply percentage formatting to a numeric value, which is useful when presenting ratios or rates in financial or operational reports.
Used in
Syntax
TO_PERCENT(value)Examples
=TO_PERCENT(0.5) // => 0.5
=TO_PERCENT(1) // => 1
=TO_PERCENT(0) // => 0