TO_PERCENT

Converts a provided number to a percentage.

Sample Usage

TO_PERCENT(A2)

TO_PERCENT(0.40826)

Syntax

TO_PERCENT(value)

  • value - The argument or reference to a cell to be converted to a percentage.

    • If value is a number or a reference to a cell containing a numeric value, TO_PERCENT returns value converted to a percentage, with the standard interpretation that 1 = 100%.

    • If value is not a number or a reference to a cell containing a numeric value, TO_PERCENT returns value without modification.

Notes

  • Because dates and percentages are both numbers, TO_PERCENT will convert dates to percentages successfully. However, these conversions are not typically meaningful.

  • TO_PERCENT is equivalent to clicking Format and then Number and then Percent from the menu bar.

See Also

UNARY_PERCENT: Returns a value interpreted as a percentage; that is, `UNARY_PERCENT(100)` equals `1`.

TO_TEXT: Converts a provided numeric value to a text value.

TO_PURE_NUMBER: Converts a provided date/time, percentage, currency or other formatted numeric value to a pure number without formatting.

TO_DOLLARS: Converts a provided number to a dollar value.

TO_DATE: Converts a provided number to a date.

N: Returns the argument provided as a number.

Examples

true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Google apps
Main menu
6525624511228507610
true
Search Help Center
true
true
true
true
true
35
false
false