Quick answer

=(A2/B2)*100 for percent; =DEGREES(ATAN(A2/B2)) for angle

Formula

  • =(rise/run)*100
  • =DEGREES(ATAN(rise/run))
  • =IF(run=0,"",(rise/run)*100)

Introduction

Sheets scale well when you have many road stations or lot grades. Compare totals with the Slope Percentage Calculator on spot checks.

Understand the math in slope percentage formula before you template cells.

Manual walkthrough: how to calculate slope percentage.

Spreadsheet workflow

Lay out columns for station, rise, run, percent, and angle. Freeze header rows so field crews know where to type.

Use IF to block divide-by-zero when run is blank. Example: =IF(B2=0,"",(A2/B2)*100).

Google Sheets uses the same function names for ATAN and DEGREES in most locales; confirm decimal separators.

Shortcut: fill down formulas after you validate row one against the calculator.

Formula and relationships

  • Percent: =(rise/run)*100
  • Angle: =DEGREES(ATAN(rise/run))

Worked scenarios: slope percentage examples.

Road-oriented labels: grade percentage calculator.

Degree context: slope percentage vs degrees.

Step-by-step guide

  1. Label columns. Rise, run, units note, percent, angle.
  2. Enter row one. Test with known 3/20 = 15%.
  3. Add percent formula. =(A2/B2)*100 with IF guard.
  4. Add angle formula. =DEGREES(ATAN(A2/B2)).
  5. Fill down. Copy formulas for all stations.
  6. Spot-check. Compare random rows to the Slope Percentage Calculator.

Template row

A2=3, B2=20 gives 15% in C2 and about 8.53 degrees in D2.

Build a second tab for negative rise downhill and format with parentheses or a sign column.