+ Reply to Thread
Results 1 to 2 of 2

Formula to convert degree of slope to percent of slope.

  1. #1
    Registered User
    Join Date
    05-11-2022
    Location
    Lake Oswego, OR
    MS-Off Ver
    Office 365
    Posts
    1

    Question Formula to convert degree of slope to percent of slope.

    I need syntax help using PI to write a formula to calculate the percent of slope when given the degree of slope. I do know I have to convert the number of degrees to radians within this formula. Thanks.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Formula to convert degree of slope to percent of slope.

    I do not know what you mean by PI. Do you mean π, or do you mean some tool or add-in? Is this an Excel question?

    The percent slope is the tangent of the angle (y/x, also called rise/run). So if you have the angle in degrees in A1, the percent slope would be

    =TAN(RADIANS(A1))

    Values as displayed
    A
    B
    1
    Angle
    Tangent (Slope %)
    2
    45
    100.0%
    3
    10
    17.6%
    4
    20
    36.4%
    5
    30
    57.7%
    Underlying formulas
    A
    B
    1
    Angle
    Tangent (Slope %)
    2
    45
    =TAN(RADIANS(A2))
    3
    10
    =TAN(RADIANS(A3))
    4
    20
    =TAN(RADIANS(A4))
    5
    30
    =TAN(RADIANS(A5))
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Formula to convert % slope to degrees angle
    By eugo in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-30-2020, 01:03 AM
  2. Getting the y-axis, x-axis and slope value given a degree
    By dluhut in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-27-2018, 06:09 AM
  3. [SOLVED] Compare the degree slope of trendlines
    By yabahoo in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 06-23-2017, 06:04 PM
  4. [SOLVED] SLOPE formula help!
    By aupa in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-07-2017, 01:59 PM
  5. Calculate Degree Of Slope
    By NeedForExcel in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-09-2016, 12:42 AM
  6. Simple Slope Formula Question
    By alecp in forum Excel General
    Replies: 2
    Last Post: 02-17-2012, 03:02 PM
  7. How to add slope formula to graph
    By jessrand in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-29-2006, 08:00 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1