What is the difference between DIVIDE and using the forward slash / operator?

DIVIDE is a named function that handles errors more explicitly, while / is an operator that crashes with #DIV/0! on zero divisors. DIVIDE also reads more clearly in complex formulas. For timesheet math, DIVIDE(hours, days) is safer than hours/days because it lets you control error behavior with IFERROR or IFNA.

Can I use DIVIDE to calculate hourly rates from total hours and project cost?

Yes. If a task cost $500 and took 40 hours, =DIVIDE(500, 40) returns 12.5, meaning $12.50 per hour. This works for any rate calculation: cost per unit, price per item, or revenue per customer.

How do I avoid #DIV/0! errors when dividing by a column that might contain zeros?

Wrap DIVIDE in IFERROR or IFNA: =IFERROR(DIVIDE(A2, B2), 0) returns 0 if B2 is zero or blank, avoiding crashes. Alternatively, use IF to check the divisor first: =IF(B2=0, 0, DIVIDE(A2, B2)).

Is DIVIDE available in Excel, or only Google Sheets?

DIVIDE is a Google Sheets function and is not available in Excel. Excel users should use the / operator or create a custom function. If you need to port formulas between sheets, plan for this difference.

DIVIDE function

DIVIDE returns the quotient of one number divided by another, with support for error handling to prevent division-by-zero crashes.

=DIVIDE(dividend, divisor)

Generate a DIVIDE formula

Describe what you need. The generator will reach for DIVIDE where DIVIDE is the right tool, and tell you when it is not.

Arguments

How DIVIDE reads its arguments

Argument	Required	Description
dividend	Required	The number to be divided (the numerator). Must be numeric; text values cause #VALUE! errors.
divisor	Required	The number to divide by (the denominator). Cannot be zero; will trigger #DIV/0! if zero.

Returns

A number representing the quotient of dividend÷divisor, or an error if inputs are invalid.

Availability

Excel: Not available · Google Sheets: Supported

Worked examples

1. Calculate average hours logged per day on a task

Task	Owner	Start	Due	Hours Logged	Days
Design mockups	Alice	2025-01-15	2025-01-20	12	6

=DIVIDE(12, 6)

Result: 2

Alice logged 12 hours over a 6-day task duration. DIVIDE returns 2, meaning she averaged 2 hours of work per day. This helps track pacing and identify when tasks run longer than expected.

2. Find what percentage of sprint capacity a team member used

Task	Owner	Hours Logged	Sprint Capacity
Frontend development	Bob	40	160
Testing & QA	Carol	8	160
Bug fixes	Alice	6	160

=DIVIDE(40, 160)

Result: 0.25

Bob logged 40 hours against a 160-hour sprint capacity (40 hours/week × 4 weeks). DIVIDE returns 0.25, or 25% when formatted as a percentage. This helps managers see how much of available capacity each person consumed.

3. Measure task efficiency by comparing expected to actual hours

Task	Owner	Expected Hours	Actual Hours
Bug fixes	Alice	8	6
Testing & QA	Carol	10	8
Design mockups	Alice	15	12

=DIVIDE(8, 6)

Result: 1.33

Alice expected to spend 8 hours on bug fixes but completed them in 6. DIVIDE(8, 6) returns 1.33, indicating she was 33% more efficient than anticipated. Ratios above 1 mean under-budget; below 1 mean over-budget.

Common errors

Which DIVIDE error are you seeing?

Error	Why it happens	How to fix it
#DIV/0!	The divisor (second argument) is zero. DIVIDE cannot divide any number by zero because the result is undefined mathematically.	Check your divisor: ensure the cell or value is not zero. Use IFERROR(DIVIDE(a, b), 0) to return 0 instead of crashing if division fails.
#VALUE!	Either dividend or divisor contains text that is not automatically convertible to a number, such as a task name or status string.	Verify both arguments are numeric cells or formulas that return numbers. Remove any accidental text values or use VALUE() to convert text numbers first.
#N/A	One of the arguments references a cell or range that contains a #N/A error from a failed LOOKUP, XLOOKUP, or similar function.	Trace the source of the #N/A error in your dividend or divisor cell. Fix the lookup first, or wrap DIVIDE in IFERROR to handle missing data gracefully.

Tips and when to use something else

Use DIVIDE instead of the / operator for better error handling: DIVIDE(a, b) gracefully handles edge cases, while a/b crashes on zero divisors.
Wrap DIVIDE in IFERROR or IFNA to provide fallback values when division fails: =IFERROR(DIVIDE(hours, days), 0) returns 0 instead of #DIV/0!.
For percentage calculations, multiply DIVIDE by 100 or format cells as percentage: =DIVIDE(40, 160) returns 0.25, then format as 25%.
When combining division with conditional logic—such as flagging over-budget tasks—use DIVIDE inside IF or IFS formulas for cleaner, more readable results.

Related functions

MULTIPLYMULTIPLY returns the product of two numbers, commonly used to calculate total inventory value, costs, or other scalar quantities in spreadsheets.MINUSSubtracts the second number from the first number and returns the resulting difference, commonly used to find gaps between values.PLUSPLUS returns the sum of two numbers, making it ideal for combining values in retail calculations and data analysis.IFERRORIFERROR returns the result of a formula unless that formula generates an error, in which case it returns a user-specified alternative value.

Frequently asked questions

What is the difference between DIVIDE and using the forward slash / operator?: DIVIDE is a named function that handles errors more explicitly, while / is an operator that crashes with #DIV/0! on zero divisors. DIVIDE also reads more clearly in complex formulas. For timesheet math, DIVIDE(hours, days) is safer than hours/days because it lets you control error behavior with IFERROR or IFNA.
Can I use DIVIDE to calculate hourly rates from total hours and project cost?: Yes. If a task cost $500 and took 40 hours, =DIVIDE(500, 40) returns 12.5, meaning $12.50 per hour. This works for any rate calculation: cost per unit, price per item, or revenue per customer.
How do I avoid #DIV/0! errors when dividing by a column that might contain zeros?: Wrap DIVIDE in IFERROR or IFNA: =IFERROR(DIVIDE(A2, B2), 0) returns 0 if B2 is zero or blank, avoiding crashes. Alternatively, use IF to check the divisor first: =IF(B2=0, 0, DIVIDE(A2, B2)).
Is DIVIDE available in Excel, or only Google Sheets?: DIVIDE is a Google Sheets function and is not available in Excel. Excel users should use the / operator or create a custom function. If you need to port formulas between sheets, plan for this difference.

Need a different formula?

The full generator is not scoped to one function — describe any spreadsheet problem and it will pick.

Open the formula generator

Reviewed 2026-09-17