I need help creating a workflow that will provide adjacent & Hypotenuse lengths.

My goal is to use a given angle (degree) in our industry and a given opposite line that is 36". I need to find the the adjacent lines length.

What I have done so far is: =(TAN(0.4)*36). .4 is the given degree or angle. The issue I have is this gives me an answer in radians. (15.22)

Looking at a trigonometric triangle: i need to find the adjacent side by inserting the given degree. i also would like to get the hypotenuse side as well.

Ultimately I would like to create a column of given degrees starting from .4 and increasing .1 degree on each line up to 50 degrees. I would like to have one column show the adjacent length and another column show hypotenuse length.

I hope I have explained well enough as I am lost so any help would be greatly appreciated.

Metalwork

you need to use cos() for that

=COS(A2)*B2 = 33.158

a rhyme I have remembered for 30 + years now...
Some Old Hens, Cackle And Howl, Til Old Age which means...

Sin=Opposite/Hypotenuse, Cos=Adj/Hyp, Tan=Opp/Adj

So, you could have column A with your angles, column B have your Adj length and column C have your formula

=COS(A2)*B2

33.158 would represent the hypotenuse correct?
I need to find the opposite as well this is the line on right angle side.

I am using +tan(A2)*B2. i am using .4 as my degree (given) and I am coming up with 15.22 length and I know the correct length is .25.

Sin=Opposite/Hypotenuse, Cos=Adj/Hyp, Tan=Opp/Adj

with those three ratios, you can calc any line, given 1 line and 1 angle, or any angle, given 2 lines. all you have to do is swap them around

In Excel, arguments to trig functions are in radians.So if the angle is 0.4 degrees, =tan(radians(0.4)) gives the tangent, which is a length, not an angle.

right-click on the cell, select formats/fractions and change the format there