# 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.

---

- **Canonical URL:** https://dothecalculation.com/blog/math/slope-percentage-excel-google-sheets-guide
- **Category:** Math
- **Author:** Do The Calculation Team
- **Published:** 2026-08-03
- **Reading time:** 10 min read
- **Publisher:** Do The Calculation (https://dothecalculation.com)
- **Methodology:** https://dothecalculation.com/methodology

---

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](/blog/math/how-to-calculate-slope-step-by-step-guide). 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!.

Tool: [Try the Slope Calculator](https://dothecalculation.com/calculators/slope-calculator) — Enter rise and run (or two points) to get slope as a percentage, ratio, and angle instantly.

## 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.

**Column Layout (row 2 is the first data row)**
| 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 |

**Basic Slope Percentage Formula**

```
Slope %: =(A2/B2)*100
```
- Rise and Run must be in the same unit — mixing feet and meters silently produces a meaningless percentage.

**Worked Example: An 8-Meter Rise Over a 200-Meter Run**
| 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 vs. Angle**

```
Slope % = (Rise ÷ Run) × 100
Angle (degrees) = DEGREES(ATAN(Rise ÷ Run))
```
- A 100% grade works out to a 45° angle, not 100 degrees — the two scales only agree at very shallow slopes and diverge sharply as the incline gets steeper.

**Converting an Existing Percentage Cell to Degrees**

```
Angle: =DEGREES(ATAN(C2/100))
```
- C2 holds the slope percentage. Dividing by 100 first converts it back to the Rise/Run ratio that ATAN expects.

_[Figure: Percentage and Angle Diverge as Slope Increases — The two scales track closely at low slopes and pull apart sharply as the grade steepens.]_

## 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.

**Ratio to Percentage**

```
Slope %: =(1/A2)*100
```
- A2 holds the "N" in a "1 in N" ratio. For a 1:20 slope, A2 = 20, and the formula returns 5%.

**Worked Example: ADA Ramp Compliance Check (Maximum 1:12)**
| 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.

**Self-Updating Conversion Table**
| 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° |

> **Why Build It This Way Instead of Typing the Numbers** — A typed table of percentages and angles is fine for a one-time reference, but it goes stale the moment you need a ratio that isn't already a row — 1:15, for instance. With formulas in columns B and C, you only ever need to type a new denominator into column A and both conversions appear automatically.

## 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.

**SLOPE() Syntax**

```
=SLOPE(known_ys, known_xs)
```
- This returns the rate of change (as a plain ratio, not a percentage) between two ranges of numbers — useful for a trend line through elevation survey points or a scatter of measurements, not for a single stated rise and run.

**Rise/Run Formula vs. SLOPE() — When to Use Each**
| 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](/blog/math/slope-in-business-and-economics-guide), 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.

**Safe Slope Formula With a Zero-Run Guard**

```
=IF(B2=0,"",(A2/B2)*100)
```
- Returns a blank cell instead of #DIV/0! whenever the Run column is empty or zero, so an unfinished row does not clutter the sheet with error values.

## 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](/blog/math/how-to-calculate-slope-step-by-step-guide), 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)

**Slope Percentage Practice Problems**
| 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](/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](/blog/math/how-to-calculate-slope-step-by-step-guide) — The core formula, real-world grade standards, and practice problems.
- [How to Find Slope From Points on a Graph](/blog/math/how-to-find-slope-points-graph-equation-guide) — Coordinate-geometry methods for finding slope from two points or an equation.
- [Slope in Business and Economics](/blog/math/slope-in-business-and-economics-guide) — Using slope and Excel's SLOPE() function for trend lines, stock beta, and cost analysis.
- [Slope, Secant Lines, Tangent Lines, and the Derivative](/blog/math/slope-secant-tangent-derivative-guide) — 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.

---

_Source: [Do The Calculation](https://dothecalculation.com/blog/math/slope-percentage-excel-google-sheets-guide). Quote freely with attribution and a link to this page._