Thread: Roof Angle
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
learnlearn52 learnlearn52 is offline
external usenet poster
 
Posts: 14
Default 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.