right triangle PLEASE HELP

[trent449]

I need to write a spread sheet that will calculate the length of 2 unknown sides of a right triangle using the following information.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
Here is what I know
1. I have a right triangle
2. I know the length of the hypotenuses
3. I know the ratio between the length of the other 2 sides
<o> </o>
I need to write and Excel file that will solve for the length of the other two sides
<o> </o>
The math look like a^2+b^2=c^2

with c being known and the ratio between a and b known<o></o>

 

[Peter_SSs]

I guess if one knows the hypotenuse length And one of the angles i can work out the length of the two adjacent sides.

I wonder what the formula would be .

Long time since studying Geometry in high school - I really need a refresher

Regards.

If the angle is measured in Radians, leave out the *PI()/180 from the formula.

Excel Workbook
	A	B	C	D
1	Hypotenuse	Angle (Degrees)	Side a	Side b
2	10	30	5	8.660254038
3	5	45	3.535533906	3.535533906
4	100	88	99.9390827	3.48994967
5
Right Triangle (2)

 

[Jaafar Tribak]

If the angle is measured in Radians, leave out the *PI()/180 from the formula.

Excel Workbook
	A	B	C	D
1	Hypotenuse	Angle (Degrees)	Side a	Side b
2	10	30	5	8.660254038
3	5	45	3.535533906	3.535533906
4	100	88	99.9390827	3.48994967
5
Right Triangle (2)

Excellent- Thanks.

 

[trent449]

You guys love to go off on tangents
Again I know the following
Right triangle
Length of C (5.9)
Ratio between A and B (11:1)
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
Logic ( my logic anyway) would tell me
A^2+b^2=C^2
So if C is 5.9 and the ratio between A:B is 11
Then
11A^2+A^2=5.9^2
Then
12A^2=5.9^2
12A^2=34.81
A^2=2.9
A=1.7
<o> </o>
Ok fine but it’s wrong! For it to be true B would have to be 1.7 x 11
So B would need to be 18.7
So plug this back into the
A^2 + b^2=C^2
1.7^2 + 18.7^2=C^2
C=18.28

 

[tusharm]

Recheck your algebra.

If B/A=11, then A^2+ (11*A)^2=C^2 or 122A^2=C^2.

You guys love to go off on tangents
Again I know the following
Right triangle
Length of C (5.9)
Ratio between A and B (11:1)
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
Logic ( my logic anyway) would tell me
A^2+b^2=C^2
So if C is 5.9 and the ratio between A:B is 11
Then
11A^2+A^2=5.9^2
Then
12A^2=5.9^2
12A^2=34.81
A^2=2.9
A=1.7
<o> </o>
Ok fine but it’s wrong! For it to be true B would have to be 1.7 x 11
So B would need to be 18.7
So plug this back into the
A^2 + b^2=C^2
1.7^2 + 18.7^2=C^2
C=18.28

 

[gardnertoo]

To expand a little on this side discussion:

Is it possible to know the length of the adjacent sides of the right rectangle without knowing the Ratio between them - (ie : just knowing the length of the hypotenuses)?

No, for any given hypotenuse, there would be an infinite number of 'other side' combinations.

Consider a circle. Every possible triangle formed by the two ends of a diameter and a third point on the circle's circumference is a right triangle, with the circle's diameter as the hypotenuse and the vertex on the circumference being the right angle. See examples below: