These docs are for v1.0. Click to read the latest docs for v1.2.

ASPERCENT

Formats a number as a percentage. The percentage is calculated as 100 times the number; for example, 0.25 will be formatted as 25%.

Syntax

=ASPERCENT(value)

Arguments

ArgumentTypeDescription
valueNumberThe number to format as a percentage

Examples

=ASPERCENT(0.5)50%
Formats the value 0.5 as a percentage

=ASPERCENT(100)10000%
Formats the value 100 as a percentage