# Google Sheets UNARY_PERCENT Function: Syntax, Examples & Tips

- URL: https://betteranalyst.com/google-sheets/unarypercent-function
- Author: Better Analyst

Formula Bot is now Better Analyst—same account, more powerful analysis.Formula Bot is now Better Analyst—same account and workflows, with more powerful analysis, dashboards, and automation.

[Learn what changed](https://betteranalyst.com/formula-bot-is-now-better-analyst)

Returns a value interpreted as a percentage, dividing it by 100; the function form of the postfix % operator.

```
=UNARY_PERCENT(percentage)
```

Generate FormulaExplain Formula

One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward.

Describe the UNARY\_PERCENT you need in plain EnglishGenerate Formula

## Parameters

| Parameter | Required | Description |
| - | - | - |
| **percentage** | Yes | The number to interpret as a percentage. The function returns this value divided by 100. |

## What Is UNARY\_PERCENT?

UNARY\_PERCENT treats its input as a percentage and returns the equivalent decimal — in other words, it divides the value by 100. `=UNARY_PERCENT(25)` returns 0.25. It is the named form of the `%` sign written after a number, so `=UNARY_PERCENT(25)` and `=25%` produce the same result.

## How UNARY\_PERCENT Relates to the `%` Operator

In Google Sheets, `%` placed after a value is a **postfix operator** that divides by 100. Google exposes each operator as a function, and the percent sign maps to UNARY\_PERCENT:

| Operator form | Function form | Result |
| - | - | - |
| `=50%` | `=UNARY_PERCENT(50)` | 0.5 |
| `=A2%` | `=UNARY_PERCENT(A2)` | A2 ÷ 100 |
| `=B2*15%` | `=B2*UNARY_PERCENT(15)` | 15% of B2 |

The word "unary" means the operator works on a single value, the same way [UMINUS](https://betteranalyst.com/google-sheets/uminus-function) (the leading `-`) and [UPLUS](https://betteranalyst.com/google-sheets/uplus-function) (the leading `+`) do.

## UNARY\_PERCENT vs. TO\_PERCENT

These two are often confused:

- **UNARY\_PERCENT changes the value**: 25 becomes 0.25. It does not apply percent formatting, so the cell may show 0.25.
- **[TO\_PERCENT](https://betteranalyst.com/google-sheets/topercent-function) changes the display**: 0.25 stays 0.25 but is shown as 25%.

To take a whole-number percentage like 25 and both convert and display it as 25%, combine them:

```
=TO_PERCENT(UNARY_PERCENT(A2))
```

## Basic Examples

### Convert a percentage to a decimal

```
=UNARY_PERCENT(8)
```

Returns 0.08.

### Calculate a percentage of an amount

```
=B2 * UNARY_PERCENT(C2)
```

If B2 is 2,000 and C2 holds 15 (meaning 15%), returns 300.

### Apply a discount

```
=B2 * (1 - UNARY_PERCENT(C2))
```

Reduces the price in B2 by the whole-number percentage in C2.

### Convert a column of whole-number percentages

```
=ARRAYFORMULA(UNARY_PERCENT(C2:C100))
```

## When Is UNARY\_PERCENT Useful?

Most of the time, typing `%` is quicker. UNARY\_PERCENT earns its place when:

- Data from another system stores percentages as whole numbers (15 meaning 15%) and you want the conversion to be explicit and easy to audit.
- You're generating formulas programmatically and prefer function calls to operator syntax.
- You want formulas to read clearly for colleagues unfamiliar with the postfix `%` operator.

## Common Use Cases

- **Tax and commission**: Rates stored as whole numbers.
- **Discount calculators**.
- **Survey data** where responses are recorded as 0–100.
- **Importing KPIs** from tools that export "45" for 45%.

## Common Errors

- **Double conversion**: If the input is already a decimal (0.15), UNARY\_PERCENT turns it into 0.0015. Check whether your data is 15 or 0.15 before converting.
- **Result looks wrong because of formatting**: If the output cell is formatted as a percent, 0.25 will display as 25% — correct, though it may look like nothing happened.
- **#VALUE!**: The input is text that can't be read as a number, such as "15 pct".

## Tips and Best Practices

- Label columns clearly as "rate (%)" (whole numbers) or "rate" (decimals).
- Use UNARY\_PERCENT once, in a helper column, rather than in every downstream formula.
- Pair with TO\_PERCENT for display.

## Related Functions

[TO\_PERCENT](https://betteranalyst.com/google-sheets/topercent-function), [UMINUS](https://betteranalyst.com/google-sheets/uminus-function), [UPLUS](https://betteranalyst.com/google-sheets/uplus-function), [MULTIPLY](https://betteranalyst.com/google-sheets/multiply-function), and DIVIDE.

## Example use case

A sales manager imports commission rates from an HR system that stores them as whole numbers (e.g. 7 for 7%). The formula =B2\*UNARY\_PERCENT(C2) multiplies each rep's revenue by the correctly converted rate to calculate commission.

## Need more help with Google Sheets formulas?

Sign up for Better Analyst and get unlimited AI-powered formula generation, explanations, and advanced data analysis.

[Create Free Account](https://betteranalyst.com/signup)[Try Formula Generator](https://betteranalyst.com/excel-ai)

## Google Sheets how-to guides

- [How To Strikethrough In Google Sheets](https://betteranalyst.com/google-sheets/how-to-strikethrough-in-google-sheets)
- [How To Subtract In Google Sheets](https://betteranalyst.com/google-sheets/how-to-subtract-in-google-sheets)
- [How To Transpose Data In Google Sheets](https://betteranalyst.com/google-sheets/how-to-transpose-data-in-google-sheets)
- [How To Unhide Columns In Google Sheets](https://betteranalyst.com/google-sheets/how-to-unhide-all-columns-in-google-sheets)
- [How To Unhide Rows In Google Sheets](https://betteranalyst.com/google-sheets/how-to-unhide-all-rows-in-google-sheets)
- [How To Unprotect Google Sheets](https://betteranalyst.com/google-sheets/how-to-unprotect-google-sheets)
- [How To Wrap Text In Google Sheets](https://betteranalyst.com/google-sheets/how-to-wrap-text-in-google-sheets)
- [Google Sheets Conditional Formatting](https://betteranalyst.com/google-sheets/google-sheets-conditional-formatting)

## Explore all Google Sheets formulas

Browse our complete library of Google Sheets formula guides

Compare your options

## Decide with evidence, not a sales pitch.

Open a neutral research prompt in the AI tool you already use. Compare capabilities, limitations, and fit before you choose.

1. [01ChatGPTOpen a balanced comparison prompt in ChatGPT.](https://chatgpt.com/?prompt=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.)
2. [02ClaudeOpen the same research prompt in Claude.](https://claude.ai/new?q=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.)
3. [03PerplexityResearch the comparison with linked web sources.](https://www.perplexity.ai/search?q=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.)

AI answers can be incomplete. Check source links, current pricing, and product documentation before deciding.