UNARY_PERCENT in Google Sheets: Convert Percentage Points
Convert numeric percentage points to decimal rates with UNARY_PERCENT in Google Sheets and avoid dividing already-stored percentages by 100 twice.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
Quick answer: =UNARY_PERCENT(12.5) has expected numeric result 0.125, equivalent to 12.5%. The function interprets the input as percentage points, dividing the number by 100. It is useful when an imported rate is stored as 12.5 instead of 0.125.
Syntax and the input scale
=UNARY_PERCENT(percentage)
The single argument is the value to interpret as a percentage. Google’s UNARY_PERCENT reference uses 100 mapping to 1 to establish the scale. There are no optional arguments or defaults.
The underscore is part of the function name. Use a numeric input and distinguish these two conventions:
- Percentage points as a number: 12.5 means “12.5 percent” only because the data definition says so; convert it to a rate.
- A stored decimal rate: 0.125 already represents 12.5%; it does not need another divide-by-100 step.
Worked example: inspect stored rates
Enter this table in A1:B5, leaving B formatted as ordinary numbers initially:
| Row | A: Example | B: Input number |
|---|---|---|
| 1 | Example | Input number |
| 2 | Rate in percentage points | 12.5 |
| 3 | One hundred percent | 100 |
| 4 | Negative change | −5 |
| 5 | Small number | 0.125 |
Put Converted rate in C1. In C2 enter and fill down to C5:
=UNARY_PERCENT(B2)
Expected numeric results: 0.125, 1, −0.05, 0.00125. If those result cells are displayed as percentages, the corresponding displays are 12.5%, 100%, −5%, 0.125%.
The last row demonstrates the hazard: converting a value already on the decimal-rate scale reduces it by another factor of 100. For a direct arithmetic check of row 2, =B2/100 has expected result 0.125.
UNARY_PERCENT and TO_PERCENT are not interchangeable
Google’s separate TO_PERCENT reference describes the standard display interpretation 1 = 100% and equates that function with choosing percentage number formatting.
=UNARY_PERCENT(12.5)produces the numeric rate 0.125.=TO_PERCENT(12.5)interprets the existing number 12.5 on the ordinary spreadsheet rate scale and displays 1250%.=TO_PERCENT(0.125)displays 12.5%.
Although the UNARY_PERCENT page describes the relationship as roughly inverse, do not treat the two functions as a general round-trip guarantee for arbitrary values and formats. Decide whether you need to change the numeric scale or only its presentation.
Advanced application: normalize an imported percentage column
On a fresh sheet, enter amounts and imported percentage-point numbers in A1:B4:
| Row | A: Base amount | B: Rate points |
|---|---|---|
| 1 | Base amount | Rate points |
| 2 | 200 | 5 |
| 3 | 200 | 10 |
| 4 | 200 | 12.5 |
In C2 enter and fill down:
=UNARY_PERCENT(B2)
Expected rates: 0.05, 0.10, 0.125. In D2 enter and fill down:
=A2*C2
Expected adjustment amounts: 10, 20, 25. Keeping the normalized rate in its own column makes the scale conversion visible and auditable.
Do not apply this conversion blindly to a mixed column containing both 12.5 and an already stored 12.5% rate. Those represent different stored numbers. Determine each source column’s declared convention before converting it.
A complete amount-plus-rate example
A hypothetical base amount is 240 and the numeric rate in percentage points is 7.5:
=240*UNARY_PERCENT(7.5)
=240*(1+UNARY_PERCENT(7.5))
Expected results: 18 for the adjustment and 258 for the total including it. This is only an arithmetic demonstration; it does not establish a tax, pricing or billing rule.
If the input is already 7.5%, its stored rate is 0.075. Applying UNARY_PERCENT to that stored rate yields 0.00075, or 0.075%, which is 100 times smaller than intended. Use the original decimal rate directly in that situation.
Errors and troubleshooting
- Display the source as a plain number to inspect its stored scale.
- Confirm the source documentation says percentage points rather than decimal rates.
- Keep conversion separate from multiplication so a factor-of-100 mistake is easy to locate.
- Check that the underscore and locale separators are correct if the formula fails to parse.
- Decide how to clean text such as an imported
12.5 percent; the function page does not document a complete text-parsing contract.
The reviewed help does not enumerate native errors or all blank, text, Boolean and array coercions. No error token or undocumented conversion behavior is inferred from another spreadsheet program. Formatting alone does not prove a value was scaled correctly.
Availability and verification
UNARY_PERCENT is documented in the rolling Google Sheets service. Original introduction date, introduction version and last functioning numbered release were not established. A migration should preserve the stored numeric rate and its interpretation; the destination may use ordinary arithmetic rather than this named function.
NOT_TESTED_IN_GOOGLE_SHEETS. Google’s individual UNARY_PERCENT and TO_PERCENT references were inspected on October 17, 2026. All rates, displays under the standard percent convention and arithmetic totals were independently derived. No native Sheets execution or screenshot is claimed.