Trig formulas

[thetank]

I am trying to write a formula to calculate the height of a side of a right triangle, where the height = (length of the base * slope of hypotenuse).

I would like to be able to enter the length of the base and the slope of the hypotenuse and then have excel calculate the height in 5 foot increments and also give the height for the "leftover" section. Ie if you have a 13 ft base, I want the heights at 5 and 10 ft and also 13 ft.

I know the formulas, I just don't know how to make excel take the initial length and then automatically increment.


Any help will be greatly appreciated.

 

[thetank]

That is correct OAKTREE.

I am trying to find the heights (Opposite side) of numerous triangles within a known triangle. Basically the hypotenuse and the adjacent sides will overlay each other and the opposite side will go towards its corresponding angle.

I wish I could draw a picture so we are both on the same "page". I am sure I am leaving something out in my explanation.

 

[Oaktree]

You're not leaving anything out.

If tan(x) = opposite / adjacent, then opposite = tan(x) * adjacent

You know adjacent, and you know x...

 

[thetank]

So how do I make excel repeat the calculation of the heights for the interior triangles for the known exterior triangles?

 

[Oaktree]

Your angle is constant, you're just adjusting the length of the adjacent side. Just use the same formula.