How to Calculate Slope Percentage in Excel and Google Sheets
A dedicated slope calculator is fine for a one-off check, but the moment you have a list of rise/run pairs, survey ratios, or a batch of grade checks to run, a spreadsheet does it faster. Here are the exact formulas — including the one most people misuse.
Slope percentage — rise divided by run, times 100 — is a one-line formula, so a single calculation rarely needs a spreadsheet at all. The moment you have a column of survey shots, a batch of ramp checks, or a list of ratios from a construction drawing, though, a spreadsheet turns a repetitive manual calculation into one formula copied down a column. This guide covers the exact formulas for Excel and Google Sheets, including the one function almost everyone reaches for by mistake.
For the underlying concept — what slope percentage means, and where the standard grade limits for roads, ramps, and roofs come from — see How to Calculate Slope Incline. This guide assumes you already know the formula and want it running efficiently in a spreadsheet.
Quick Answer
- Slope Percentage = (Rise ÷ Run) × 100 — in a spreadsheet, that is =(A2/B2)*100.
- A 100% grade is a 45° angle, not 100 degrees — percentage and angle are two different scales.
- To convert percentage to an angle: =DEGREES(ATAN(C2/100)).
- The SLOPE() function is for linear-regression data points (a list of x,y pairs), not for a single rise/run pair — using it on rise and run directly returns a meaningless result.
- Always guard rise/run formulas against a zero run with an IF check, or Excel returns #DIV/0!.
The Basic Rise/Run Formula in a Spreadsheet
Set up three columns — Rise, Run, and Slope % — and let the formula do the division for every row.
Swipe sideways to compare columns.
| Column | Header | Contains |
|---|---|---|
| A | Rise | A typed number, e.g. 8 (feet, meters, or any consistent unit) |
| B | Run | A typed number in the same unit as Rise, e.g. 200 |
| C | Slope % | Formula: =(A2/B2)*100 |
Swipe sideways to compare columns.
| Cell | Value or Formula | Result |
|---|---|---|
| A2 | 8 (typed) | 8 |
| B2 | 200 (typed) | 200 |
| C2 | =(A2/B2)*100 | 4% |
Percent vs. Degrees — Two Different Scales, One Common Formula Mix-Up
Slope percentage and the angle of inclination follow different math entirely, and confusing the two in a spreadsheet formula produces numbers that look plausible but are wrong.
Percentage and Angle Diverge as Slope Increases
The two scales track closely at low slopes and pull apart sharply as the grade steepens.
At 10% grade the angle (5.71°) is close to the percentage value. By 200% grade the angle (63.43°) is far below the percentage number — the two scales are not interchangeable at steep inclines.
Converting a Ratio (1 in N) to a Percentage in a Spreadsheet
Construction drawings and accessibility codes often express slope as a ratio — "1 in 20" or "1:12" — rather than a percentage. Converting is the same division, just framed differently.
Swipe sideways to compare columns.
| Cell | Value or Formula | Result |
|---|---|---|
| A2 | 12 (typed, the "N" in 1:12) | 12 |
| B2 | =(1/A2)*100 | 8.33% |
Building a Ratio → Percentage → Angle Table That Updates Itself
Rather than typing out percentage and angle values for every ratio you might need, put the ratio denominators in one column and let two formulas fill in the rest — the table recalculates automatically if you add or edit a ratio.
Swipe sideways to compare columns.
| A (Ratio 1:N) | B (Percentage) | C (Angle) |
|---|---|---|
| 100 | =(1/A2)*100 → 1.00% | =DEGREES(ATAN(1/A2)) → 0.57° |
| 60 | =(1/A3)*100 → 1.67% | =DEGREES(ATAN(1/A3)) → 0.95° |
| 40 | =(1/A4)*100 → 2.50% | =DEGREES(ATAN(1/A4)) → 1.43° |
| 20 | =(1/A5)*100 → 5.00% | =DEGREES(ATAN(1/A5)) → 2.86° |
| 12 | =(1/A6)*100 → 8.33% | =DEGREES(ATAN(1/A6)) → 4.76° |
| 10 | =(1/A7)*100 → 10.00% | =DEGREES(ATAN(1/A7)) → 5.71° |
Using SLOPE() for Data Points — Not for a Single Rise/Run Pair
Excel and Google Sheets both have a built-in SLOPE() function, and it is frequently confused with the rise/run formula above. SLOPE() calculates the slope of the best-fit line through a set of (x, y) data points — it is a linear-regression tool, not a shortcut for a single rise-over-run calculation.
Swipe sideways to compare columns.
| Situation | Use |
|---|---|
| You have one rise value and one run value | =(Rise/Run)*100 |
| You have a list of (x, y) survey or trend points | =SLOPE(known_ys, known_xs), then multiply by 100 for a percentage |
| You want the grade of a road or ramp from a single measurement | =(Rise/Run)*100 |
| You want the best-fit trend across many elevation readings | =SLOPE(known_ys, known_xs) |
For a full walkthrough of SLOPE() in a business or trend-analysis context — stock beta, a cost line, a demand curve — see Slope in Business and Economics, which covers that use case in depth.
Handling #DIV/0! Errors When Run Is Zero or Blank
A blank or zero Run value triggers a division-by-zero error the moment a row is only partially filled in — common when a spreadsheet is still being populated. An IF guard keeps the sheet clean instead of showing an error in every empty row.
Real-World Spreadsheet Uses at a Glance
- Highway and road grading — batch-checking a list of survey stations against a 6–8% maximum grade.
- ADA ramp compliance — verifying a list of proposed ramps against the 1:12 (8.33%) maximum running slope.
- Roof pitch conversion — converting a list of pitches given as ratios (4:12, 6:12) into percentages for a materials spec sheet.
- Land grading and drainage — checking a batch of grading points meet a minimum 1–2% slope for water runoff.
For the standards behind each of these — the specific maximum and minimum grades used in road construction, ramps, roofs, drainage, trails, and ski runs — see How to Calculate Slope Incline, which covers all seven in detail.
Common Mistakes to Avoid
- Entering a percentage as a whole number instead of a true percentage-formatted cell, then multiplying by 100 a second time by mistake.
- Using SLOPE() on a single rise and run value instead of the direct division formula — SLOPE() needs at least two data points to mean anything.
- Forgetting the #DIV/0! guard, which leaves error values scattered through an otherwise-clean sheet.
- Mixing units between Rise and Run (feet in one column, meters in the other) without converting first.
- Reading a "1:20" ratio backwards — it means 1 unit of rise for every 20 units of run, not the other way around.
- Reporting an angle in degrees as if it were a percentage, or vice versa — a 45° angle and a 45% grade are very different steepnesses.
Practice Problems (With Answers)
Swipe sideways to compare columns.
| Problem | Answer |
|---|---|
| A driveway rises 6 feet over a 50-foot run. What is the slope percentage? | (6/50) × 100 = 12% |
| A drawing specifies a 1:15 slope. What percentage is that? | (1/15) × 100 = 6.67% |
| A ramp has a 9% grade. What is the angle in degrees? | DEGREES(ATAN(0.09)) = 5.14° |
| A trail rises 45 feet over a 300-foot run. Does it meet a "difficult" (10–20%) trail rating? | (45/300) × 100 = 15% — yes, within the difficult range |
Frequently Asked Questions
What is the formula for slope percentage in Excel?
With rise in A2 and run in B2, use =(A2/B2)*100. Make sure both values use the same unit of measurement.
Why does #DIV/0! appear in my slope formula?
The run value in that row is zero or blank. Guard the formula with =IF(B2=0,"",(A2/B2)*100) to return a blank cell instead of an error.
Can I use the SLOPE() function for a simple rise-over-run calculation?
You can, but it is the wrong tool for a single pair of values — SLOPE() is built for a range of (x, y) data points and calculates the slope of the best-fit regression line through them, not a direct division.
How do I convert slope percentage to degrees in Google Sheets?
Use =DEGREES(ATAN(C2/100)), where C2 holds the percentage. The formula is identical in Excel.
Is a 100% grade the same as a 45-degree angle?
Yes — a 100% grade means the rise equals the run, and arctan(1) is exactly 45°. A 100% grade is not a 100-degree angle.
How do I convert a "1 in N" ratio to a percentage?
Divide 1 by N and multiply by 100: =(1/A2)*100, where A2 holds the N value. A 1-in-20 slope is (1/20) × 100 = 5%.
What is the maximum slope allowed for an ADA-compliant ramp?
The 2010 ADA Standards for Accessible Design (Section 405.2) set a maximum running slope of 1:12, equal to 8.33% or 4.76°, with additional requirements for rise per run and landing length.
Do Excel and Google Sheets use the same slope formulas?
Yes. The rise/run division, the SLOPE() function, and the DEGREES(ATAN()) conversion all work identically in both applications.
Why do percentage and degrees diverge more at steeper slopes?
Percentage is a straight-line ratio (rise/run × 100), while degrees follow the arctangent function, which grows more slowly as the ratio increases. The two scales are close at shallow slopes and increasingly far apart as the incline steepens, converging only at the extremes.
Can I build a slope conversion table that updates automatically?
Yes — put your ratio denominators in one column, then use =(1/A2)*100 and =DEGREES(ATAN(1/A2)) in adjacent columns. Any new ratio you add automatically gets both conversions.
Sources
- U.S. Access Board — 2010 ADA Standards for Accessible Design, Chapter 4 and Section 405 (Ramps): https://www.access-board.gov/ada/
Related Guides and Calculators
- Slope Calculator — Calculate slope as a percentage, ratio, and angle from rise and run or two points.
- How to Calculate Slope Incline: A Complete Guide — The core formula, real-world grade standards, and practice problems.
- How to Find Slope From Points on a Graph — Coordinate-geometry methods for finding slope from two points or an equation.
- Slope in Business and Economics — Using slope and Excel's SLOPE() function for trend lines, stock beta, and cost analysis.
- Slope, Secant Lines, Tangent Lines, and the Derivative — Where slope leads next in calculus.
Final Summary
Slope percentage in a spreadsheet is one formula — =(Rise/Run)*100 — copied down as many rows as you need. The mistakes worth avoiding are reaching for SLOPE() when you have a single rise and run instead of a data set, confusing a percentage with an angle, and forgetting to guard against a blank or zero run. Get those three right and a spreadsheet turns a batch of slope checks into a few seconds of work.
Written by
Do The Calculation Team
Do The Calculation Editorial Board
The Do The Calculation Editorial Board is comprised of software engineers, finance analysts, and technical contributors focused on building clean, accurate, and easy-to-use calculator tools.
Reviewed & Verified By
Dr. Elena Rostova, PhD
Mathematics Advisor
Professor of mathematics with 20+ years of teaching experience. Dr. Rostova oversees the formulas, proofs, and algorithms behind our math division tools, fractions, logarithms, and scientific equations.