Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Roof Angle
I need to know how to convert the roof pitch stated at 6/12 into degrees. I
know I have a rise of six inches per foot. I am using Excel 2007 and cannot seem to get the formula correct. Please help me out. This is really bugging me Thanks -- Amos |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Roof Angle
hi
in trig... TAN(a)=Rise/Run but all that will give you is 50% slope(grade). see this site.... http://www.1728.com/gradient.htm it will calculate degrees, grades, etc. I think you want to calculate ratio. Regards FSt1 "Amos Carver" wrote: I need to know how to convert the roof pitch stated at 6/12 into degrees. I know I have a rise of six inches per foot. I am using Excel 2007 and cannot seem to get the formula correct. Please help me out. This is really bugging me Thanks -- Amos |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Roof Angle
maybe this will help
http://www.math.com/school/subject3/.../S3U3L4DP.html -- Gary Keramidas Excel 2003 "Amos Carver" wrote in message ... I need to know how to convert the roof pitch stated at 6/12 into degrees. I know I have a rise of six inches per foot. I am using Excel 2007 and cannot seem to get the formula correct. Please help me out. This is really bugging me Thanks -- Amos |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Roof Angle
"Amos Carver" wrote: I need to know how to convert the roof pitch stated at 6/12 into degrees. I know I have a rise of six inches per foot. I am using Excel 2007 and cannot seem to get the formula correct. Please help me out. This is really bugging me Thanks -- Amos Try this formula: =DEGREES(ATAN(rise/run)) You can make two columns, the first column being the rise, and the second column being the run. The third column is the calculated ratio of the rise/run. In the fourth column type the above formula. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
angle from atan | New Users to Excel | |||
degree or angle | Excel Worksheet Functions | |||
If I know that a value in a cell is the TAN of an Angle, How do I | Excel Discussion (Misc queries) | |||
How to calculate future cost of roof | Excel Worksheet Functions | |||
How to angle columns? Please Help! | Excel Discussion (Misc queries) |