How to calculate the length of the side of a triangle?

Scott M

Board Regular
Joined
Dec 31, 2011
Messages
152
I was wandering If some one could help me with this formula
I need to find the length of 1 side of a triangle when the longest side is known and the angle is known
for example the longest side is 16 inches and the angle is 90 deg.
http://screencast.com/t/7qENS4FCN
 
Last edited:

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
Hi,

Basically, it is the Pythagorean theorem : <dl style="margin-top: 0.2em; margin-bottom: 0.5em; color: rgb(0, 0, 0); font-family: sans-serif; line-height: 19.1875px;"><dd style="line-height: 1.5em; margin-left: 1.6em; margin-bottom: 0.1em; margin-right: 0px;">
1455314a78f39a594485adbaf74d63f9.png
</dd></dl>where c represents the length of the hypotenuse ( the longest side), and a and b represent the lengths of the other two sides.

Cheers
 
Upvote 0
That original picture isn't 45 deg, but if the triangle is 45 and 45, each other side is simply

=SQRT(16^2/2)
 
Upvote 0
For other angles, the side to the left (adjacent) is:
=COS(RADIANS(angle))*hypotenuse
and the opposite side is:
=SIN(RADIANS(angle))*hypotenuse
 
Upvote 0
The Pythagorean theorm applies only to right triangles. A more general formula that works with any angle is the Law Of Cosines
Given a triangle where sides A, B and C are across from angles a, b, and c, the Law of Cosines says that

A^2 = (B^2)+(C^2) - (2*B*C*Cos(a))

(Note that if a is a right angle, this becomes the pythagorean theorem.)

There is also the triple equality called the Law Of Sines

A/Sin(a) = B/Sin(b) = C/Sin(c)

With these two equations (and enough information), any triangle can be solved.
 
Last edited:
Upvote 0
Thank you all for your help. With the information that you provided I think that I can for sure accomplish what I want.
 
Upvote 0

Forum statistics

Threads
1,214,905
Messages
6,122,175
Members
449,071
Latest member
cdnMech

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top