# Google Sheets TO_PERCENT Function: Syntax, Examples & Tips - URL: https://betteranalyst.com/google-sheets/topercent-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) Converts a number to a value formatted as a percentage. ``` =TO_PERCENT(value) ``` Generate FormulaExplain Formula One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward. Describe the TO\_PERCENT you need in plain EnglishGenerate Formula ## Parameters | Parameter | Required | Description | | - | - | - | | **value** | Yes | The number, or reference to a cell containing a number, to format as a percent. Non-numeric values are returned unchanged. | ## What Is TO\_PERCENT? TO\_PERCENT returns a number with percentage formatting applied. The key thing to understand is that percentages in spreadsheets are fractions of 1: the value 0.25 displays as 25%. TO\_PERCENT does **not** divide by 100 — it simply changes how the number is shown. So `=TO_PERCENT(0.25)` displays `25%`, while `=TO_PERCENT(25)` displays `2500%`. ## How TO\_PERCENT Relates to the % Operator Google Sheets also has a postfix `%` operator, whose function form is [UNARY\_PERCENT](https://betteranalyst.com/google-sheets/unarypercent-function). They do different jobs: | Formula | What happens | Displays | | - | - | - | | `=TO_PERCENT(0.25)` | Formats 0.25 as a percent | 25% | | `=25%` | Divides 25 by 100 | 0.25 (or 25% if formatted) | | `=UNARY_PERCENT(25)` | Divides 25 by 100 | 0.25 | | `=TO_PERCENT(UNARY_PERCENT(25))` | Divides, then formats | 25% | Use TO\_PERCENT when your number is already a ratio; use UNARY\_PERCENT (or `%`) when it's a whole-number percentage that needs converting to a ratio. ## Basic Examples ### Format a ratio ``` =TO_PERCENT(0.075) ``` Displays `7.50%` (the number of decimals shown may vary with the format Sheets applies). ### Conversion rate ``` =TO_PERCENT(C2 / B2) ``` Divides conversions by visitors and shows the result as a percentage. ### Growth rate ``` =TO_PERCENT((C2 - B2) / B2) ``` Shows period-over-period change as a percentage. ### Share of total ``` =ARRAYFORMULA(TO_PERCENT(B2:B20 / SUM(B2:B20))) ``` ## How TO\_PERCENT Behaves - **The value stays numeric**, so you can continue to calculate with it. `=TO_PERCENT(0.2) * 100` returns 20. - **Non-numeric values are returned unchanged** rather than producing an error. - **Precision is preserved**; only the display changes. Use ROUND to fix the stored precision. ## Common Use Cases - **Marketing metrics**: CTR, conversion rate, bounce rate. - **Finance**: Margins, growth rates, budget utilisation. - **Reporting**: Percent of total in summary tables produced by QUERY or ARRAYFORMULA, where cell formatting is lost. - **Grades**: Score divided by maximum, shown as a percent. ## Common Errors - **Results like 2500%**: The input was already a whole-number percentage. Divide by 100 first, or use UNARY\_PERCENT. - **Concatenation drops the format**: `="Rate: "&TO_PERCENT(B2)` shows the raw decimal. Use `TEXT(B2, "0.0%")` inside text. - **#DIV/0! from rate formulas**: When the denominator is zero, wrap the division: `=TO_PERCENT(IFERROR(C2/B2, 0))`. ## Tips and Best Practices - Keep percentages stored as fractions (0.25) throughout your sheet; it makes every downstream calculation simpler. - Use TO\_PERCENT inside array formulas and QUERY-driven reports where you can't pre-format cells. - For a specific number of decimals in the display, apply a custom format or use TEXT for text output. ## Related Functions [UNARY\_PERCENT](https://betteranalyst.com/google-sheets/unarypercent-function), [TO\_DOLLARS](https://betteranalyst.com/google-sheets/todollars-function), [TO\_TEXT](https://betteranalyst.com/google-sheets/totext-function), [TO\_PURE\_NUMBER](https://betteranalyst.com/google-sheets/topurenumber-function), TEXT, and PERCENTRANK. ## Example use case A growth marketer calculates click-through rates from impressions in column B and clicks in column C. =TO\_PERCENT(C2/B2) shows each campaign's CTR as a percentage, and because the result is still numeric, she can sort and average the column directly. ## 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 Lock A Row In Google Sheets](https://betteranalyst.com/google-sheets/how-to-lock-a-row-in-google-sheets) - [How To Lock Cells In Google Sheets](https://betteranalyst.com/google-sheets/how-to-lock-cells-in-google-sheets) - [How To Make A Copy Of An Google Sheets Sheet](https://betteranalyst.com/google-sheets/how-to-make-a-copy-of-an-google-sheets-sheet) - [How To Make A Graph In Google Sheets](https://betteranalyst.com/google-sheets/how-to-make-a-graph-in-google-sheets) - [How To Make A Histogram In Google Sheets](https://betteranalyst.com/google-sheets/how-to-make-a-histogram-in-google-sheets) - [How To Make A Line Graph In Google Sheets](https://betteranalyst.com/google-sheets/how-to-make-a-line-graph-in-google-sheets) - [How To Make A Pie Chart In Google Sheets](https://betteranalyst.com/google-sheets/how-to-make-a-pie-chart-in-google-sheets) - [How To Make A Table In Google Sheets](https://betteranalyst.com/google-sheets/how-to-make-a-table-in-google-sheets) ## 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.