LinkBack URL
About LinkBacks
Hi all,
I have done a search but couldn't find anything that helped.
I am trying to work out how to convert the slope/gradient from degrees to %, and ratio.
Any hints on how to write the equation?
Hi all,
I have done a search but couldn't find anything that helped.
I am trying to work out how to convert the slope/gradient from degrees to %, and ratio.
Any hints on how to write the equation?
Last edited by The Big Galoot; 02-18-2009 at 05:27 PM.
do you want to convert say 45 degrees slope to a ratio/percent?
if so
Degrees of slope/90 x 100 will give % 45/90 =1/2 i.e 1 in 2
if you have the analysis toolpak activated
then as a ratio try
=A1/GCD(A1,B1) &":"& B1/GCD(A1,B1)
when a1=1 b1=2 result is 1:2
where a1 is numerator b1 denominator
Last edited by martindwilson; 02-13-2009 at 08:14 PM.
45 degree slope is 1:1, or 100%
I have a list of degrees in a spreadsheet such as:
1
2
3
4
to
45
I am trying to work out the excel formula for converting this column (degrees) to both a % and a ratio.
oops my mistake 1 in 1 is 45 degrees. and thats considered as a 100% slope
but degree of slope say 2:4 is
arc tangent(.5) = 26.565 degrees
Last edited by martindwilson; 02-13-2009 at 08:40 PM.
If A1 has the slope in degrees, then
=tan(radians(a1))
Format as percent to see percent, or as a fraction to see a ratio.
Entia non sunt multiplicanda sine necessitate
That worked a treat, thanks shg.Originally Posted by shg
You’re welcome. Would you be so kind as to mark the thread as Solved?
Click the Edit button on your first post in the thread
Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes
try
=TAN(A1*0.0174532925 ) where a1 is degrees
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks