Calculate Roof degrees

mortenkh

New Member
Joined
Jan 3, 2018
Messages
3
Hello every1

I need yor help to calculate the roof degrees. i am a little limit on my english regarding term on roof, slope (rise) and all these words :(

but to come up with an exxample
height to ridge is 6m and wall height is 2,6m which means we have 3,4m height in attic room.
the house width is 20m/2 then we have 10m to the middle and a rectangular triangle.

In Cell A1 i have 3,4m for the height
In Cell A2 i have 10m for half the building lenght

Which formula should i use in cell A3 to find the roof degrees?


EDIT: By attic room i mean measure from ceiling to ridge
 
Last edited by a moderator:

Some videos you may like

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

farmerscott

Well-known Member
Joined
Jan 26, 2013
Messages
809
Office Version
365
Platform
Windows
Hi,

I am going back over some maths that I learnt over 30 years ago but I think....

In cell A3 try =DEGREES(TAN(A1/A2)).

I get an angle of 18.8%, does that sound right?

cheers,

Farmerscott
 

Watch MrExcel Video

Forum statistics

Threads
1,100,209
Messages
5,473,184
Members
406,849
Latest member
gustavor0

This Week's Hot Topics

Top