Check Sheet Logo
Check Sheet

TO_PERCENT

The TO_PERCENT formula is used to convert a decimal number to a percentage value. It takes a single argument, the value to be converted. The resulting value is a string with a percent sign (%) appended. This function is commonly used in financial calculations or when working with data that needs to be displayed as a percentage.

Usage

Use the TO_PERCENT formula with the syntax shown below, it has 1 required parameter:

=TO_PERCENT(value)
Parameters:
  1. value (required):
    The decimal number to be converted to a percentage. This value must be a number between 0 and 1.

Examples

Here are a few example use cases that explain how to use the TO_PERCENT formula in Google Sheets.

Converting a decimal to a percentage

The TO_PERCENT formula can be used to quickly convert a decimal value to a percentage. For example, if you have a decimal value of 0.75, you can use TO_PERCENT(0.75) to get the percentage value of 75%.

Calculating percentage increase or decrease

The TO_PERCENT formula can be used in combination with other formulas to calculate percentage increase or decrease. For example, if you have two values in cells A1 and A2, you can use the formula TO_PERCENT((A2-A1)/A1) to calculate the percentage increase or decrease between the two values.

Formatting percentage values

The TO_PERCENT formula can be used to format percentage values in a consistent manner. For example, if you have a column of decimal values that you want to display as percentages, you can use the formula TO_PERCENT(B2) and drag the formula down the column to apply it to all values.

Common Mistakes

TO_PERCENT not working? Here are some common mistakes people make when using the TO_PERCENT Google Sheets Formula:

Incorrect argument type

The TO_PERCENT formula only accepts a single argument that is a numerical value. If you provide it with a non-numerical value, it will return an error. To fix this, make sure to provide a numerical value as the argument.

Missing argument

If you forget to provide an argument to the TO_PERCENT formula, it will return an error. To fix this, make sure to provide a numerical value as the argument.

Percentage not displayed

The TO_PERCENT formula returns a decimal number that represents a percentage. If you want to display the result as a percentage, you will need to format the cell as a percentage. To do this, select the cell and click on the % button in the toolbar.

Related Formulas

The following functions are similar to TO_PERCENT or are often used with it in a formula:

  • TO_DOLLARS

    TO_DOLLARS is not a valid Google Sheets formula.

  • PERCENTILE

    The PERCENTILE function returns the value at a given percentile of a dataset. This can be useful in statistics and data analysis when trying to find the value that corresponds to a certain percentile in a set of data.

  • PERCENTRANK

    The PERCENTRANK formula in Google Sheets returns the percentage rank of a specified value within a dataset. It calculates the percentage of values in a given range that are less than or equal to the specified value. This formula is commonly used in statistical analysis to determine the relative standing of a particular value within a dataset.

  • AVERAGE

    The AVERAGE function calculates the average (arithmetic mean) of the values passed to it. It is commonly used to find the average of a range of cells containing numerical data.

  • SUM

    The SUM function in Google Sheets adds up a range of numbers. This function is most commonly used to sum the values in a range of cells.

Learn More

You can learn more about the TO_PERCENT Google Sheets function on Google Support.