# 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:

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.

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.

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