TO_PERCENT
TheTO_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.
 How to use
TO_PERCENT
formula?  Examples of using
TO_PERCENT
formula TO_PERCENT
formula not working? Similar formulas to
TO_PERCENT
Usage
Use the TO_PERCENT
formula with the syntax shown below, it has 1 required parameter:
 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 theTO_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((A2A1)/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 nonnumerical 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.