# Google Sheets DIVIDE Function: Syntax, Examples & Tips - URL: https://betteranalyst.com/google-sheets/divide-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 one number divided by another, the same as using the / operator. ``` =DIVIDE(dividend, divisor) ``` Generate FormulaExplain Formula One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward. Describe the DIVIDE you need in plain EnglishGenerate Formula ## Parameters | Parameter | Required | Description | | - | - | - | | **dividend** | Yes | The number to be divided (the numerator). | | **divisor** | Yes | The number to divide by (the denominator). Cannot be zero. | ## What Is DIVIDE? DIVIDE is the function version of the division operator in Google Sheets. `=DIVIDE(A1, B1)` returns exactly what `=A1/B1` returns: the first value divided by the second. It belongs to the same family of operator functions as [ADD](https://betteranalyst.com/google-sheets/add-function), MINUS, and MULTIPLY. ## How DIVIDE Works DIVIDE takes **two arguments**: the **dividend** (the number being split up) and the **divisor** (the number you are splitting by). It returns dividend ÷ divisor. Both arguments must be single numeric values. If the divisor is zero or an empty cell, the function returns `#DIV/0!`. ## Basic Examples ### Divide two numbers ``` =DIVIDE(100, 8) ``` Returns 12.5. ### Divide one cell by another ``` =DIVIDE(B2, C2) ``` If B2 holds total revenue and C2 holds the number of orders, the result is average order value. ### Calculate a percentage ``` =DIVIDE(B2, B10) ``` Divides one line item by the grand total. Format the cell as a percentage to show, for example, 23.5%. ### Divide and round ``` =ROUND(DIVIDE(B2, C2), 2) ``` Divides and rounds the result to two decimal places, useful for currency. ## Handling Division by Zero The most common problem with division is a zero or blank divisor. Wrap DIVIDE in IFERROR or an [IF](https://betteranalyst.com/google-sheets/if-function) check to show something friendlier than `#DIV/0!`: ``` =IFERROR(DIVIDE(B2, C2), 0) ``` Returns 0 whenever the division fails. ``` =IF(C2=0, "", DIVIDE(B2, C2)) ``` Leaves the cell blank when the divisor is zero, and divides otherwise. This version is more precise, because IFERROR also hides other errors (such as text in B2) that you might want to see. ## DIVIDE vs. the / Operator | Feature | DIVIDE | / operator | | - | - | - | | Result | dividend ÷ divisor | dividend ÷ divisor | | Number of inputs | Exactly 2 | Chainable | | Readability | Spelled out as a function | Compact | | Behaviour on zero | `#DIV/0!` | `#DIV/0!` | There is no difference in the answer. Choose whichever reads better in your sheet. ## Dividing Whole Columns Combine DIVIDE with ARRAYFORMULA to divide one column by another in a single formula: ``` =ARRAYFORMULA(IF(C2:C="", "", DIVIDE(B2:B, C2:C))) ``` This calculates a ratio for every row and leaves rows blank where no divisor exists. ## Common Use Cases - **Ratios and rates**: cost per click, revenue per user, conversion rate - **Shares of a total**: each region's portion of company sales - **Unit pricing**: package price divided by quantity - **Averages by hand**: a total divided by a count, for example `=DIVIDE(SUM(B2:B50), COUNT(B2:B50))` - **Splitting costs**: a bill divided by the number of people ## Common Errors - **#DIV/0!**: The divisor is 0 or blank. Use IF or IFERROR as shown above. - **#VALUE!**: One of the arguments is text that cannot be converted to a number. - **Wrong argument order**: `=DIVIDE(C2, B2)` gives the reciprocal of what you meant. The number being divided always comes first. - **Too many arguments**: DIVIDE accepts exactly two values. For a chain such as a ÷ b ÷ c, nest the function or use `/`. ## Tips and Best Practices - When you build a percentage, divide first and then apply percentage formatting rather than multiplying by 100. The underlying value stays usable in other formulas. - For the remainder after division, use MOD. For the whole-number part, use QUOTIENT. - Use absolute references (`$B$10`) for a fixed total so you can copy the formula down a column. - When calculating a mean, [AVERAGE](https://betteranalyst.com/google-sheets/average-function) is shorter and ignores blanks automatically. ## Related Functions - [ADD](https://betteranalyst.com/google-sheets/add-function): the function form of the + operator - [AVERAGE](https://betteranalyst.com/google-sheets/average-function): divides a total by a count for you - [ROUND](https://betteranalyst.com/google-sheets/round-function): tidies up long decimal results - [IF](https://betteranalyst.com/google-sheets/if-function): guards against dividing by zero - [SUM](https://betteranalyst.com/google-sheets/sum-function): builds totals to divide ## Example use case A marketing analyst has ad spend in column B and conversions in column C. Using =IF(C2=0, "", DIVIDE(B2, C2)), they calculate cost per conversion for each campaign without showing #DIV/0! for campaigns with no conversions yet. ## 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 Divide In Google Sheets](https://betteranalyst.com/google-sheets/how-to-divide-in-google-sheets) - [How To Freeze A Row In Google Sheets](https://betteranalyst.com/google-sheets/how-to-freeze-a-row-in-google-sheets) - [How To Freeze Panes In Google Sheets](https://betteranalyst.com/google-sheets/how-to-freeze-panes-in-google-sheets) - [How To Highlight Duplicates In Google Sheets](https://betteranalyst.com/google-sheets/how-to-highlight-duplicates-in-google-sheets) - [How To Insert Checkbox In Google Sheets](https://betteranalyst.com/google-sheets/how-to-insert-checkbox-in-google-sheets) - [How To Insert Multiple Rows In Google Sheets](https://betteranalyst.com/google-sheets/how-to-insert-multiple-rows-in-google-sheets) - [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) ## 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.