+ Reply to Thread
Results 1 to 7 of 7

Formula to convert % slope to degrees angle

  1. 12-29-2020, 06:09 AM #1
    eugo
    eugo is offline
    Registered User
    Join Date
    12-29-2020
    Location
    Philippines
    MS-Off Ver
    2016
    Posts
    3

    Post Formula to convert % slope to degrees angle

    Hi,

    Can anyone could help me. I need to convert % slope value to degrees angle using excel.
    Many thanks!
    Reply With QuoteRegister To Reply
  2. 12-29-2020, 06:10 AM #2
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    81,238

    Re: Formula to convert % slope to degrees angle

    Welcome to the forum.

    There are instructions at the top of the page explaining how to attach your sample workbook.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 12-29-2020, 07:13 AM #3
    torachan
    torachan is offline
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,305

    Re: Formula to convert % slope to degrees angle

    % slope/100 = tan angle
    50%/100 = 0.5 =26.6 degrees
    Reply With QuoteRegister To Reply
  4. 12-29-2020, 08:58 AM #4
    joppert87
    joppert87 is offline
    Registered User
    Join Date
    03-07-2012
    Location
    Belgium
    MS-Off Ver
    365
    Posts
    5

    Re: Formula to convert % slope to degrees angle

    Hey,
    if you value is in percentage (eg 5% = 0.05) in cell A1:
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 12-29-2020, 11:08 PM #5
    eugo
    eugo is offline
    Registered User
    Join Date
    12-29-2020
    Location
    Philippines
    MS-Off Ver
    2016
    Posts
    3

    Re: Formula to convert % slope to degrees angle

    thanks a lot!
    Reply With QuoteRegister To Reply
  6. 12-29-2020, 11:08 PM #6
    eugo
    eugo is offline
    Registered User
    Join Date
    12-29-2020
    Location
    Philippines
    MS-Off Ver
    2016
    Posts
    3

    Re: Formula to convert % slope to degrees angle

    thank you so much!
    Reply With QuoteRegister To Reply
  7. 12-30-2020, 01:03 AM #7
    hrlngrv
    hrlngrv is offline
    Forum Expert
    Join Date
    07-06-2004
    Location
    Northern California
    MS-Off Ver
    2K, 2003, 2010, O365
    Posts
    1,490

    Re: Formula to convert % slope to degrees angle

    Or =DEGREES(ATAN(A1)).
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Best way to convert Degrees Minutes and Seconds to Decimal of Degrees (and Vice Versa)
    By Aussie_Student in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-05-2017, 02:12 AM
  2. VBA code that converts Bearing angle in degrees to Azimuth
    By Farhat95 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-14-2017, 10:31 PM
  3. [SOLVED] how can i convert degrees/minutes/seconds to decimal degrees?
    By russkris in forum Excel General
    Replies: 14
    Last Post: 03-03-2015, 04:32 AM
  4. [SOLVED] finding angle of slope...
    By Brad in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-21-2006, 06:25 PM
  5. [SOLVED] how can i convert degrees/minutes/seconds to decimal degrees?
    By Chrissy in forum Excel General
    Replies: 2
    Last Post: 04-28-2006, 07:20 AM
  6. Plot R-Theta [angle (0~360 degrees) and amplitude] chart in Excel
    By Wes12 in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 01-28-2006, 08:35 PM
  7. [SOLVED] convert an angle to degrees minutes seconds
    By Mac in forum Excel General
    Replies: 1
    Last Post: 03-22-2005, 12:06 AM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1