calculate chord when angle and radius are known.

[old man factor]

Trying to get a formula to calculate chord when angle and radius are known and would like to be able to calculate distance from chord to center of radius as well.

Please......

 

[Tetra201]

With angle (degrees) in cell A1 and and radius in cell B1:

Chord =2*B1*SIN(RADIANS(A1/2))

Distance =B1*COS(RADIANS(A1/2))

 

[old man factor]

With angle (degrees) in cell A1 and and radius in cell B1:

Chord =2*B1*SIN(RADIANS(A1/2))

Distance =B1*COS(RADIANS(A1/2))

Didn't work! Typed in just like it reads... MMMMMM

90

8

=2*B1*SIN(RADIANS(A1/2))

<colgroup><col width="312"><col width="81"><col span="2" width="64"><col width="111"></colgroup><tbody>
</tbody>

90 is degrees and 8 is radius - displays but doesn't calculate anything. ????

 

[AhoyNC]

Formulas worked when I tried them.

Excel Workbook
	A	B	C	D
1	Angle	110
2	radius	8
3	Chord	13.106
4	Dist. Chord to Center	4.589	or	4.589
Sheet

 

[old man factor]

Formulas worked when I tried them.

	A	B	C	D
1	Angle	110
2	radius	8
3	Chord	13.106
4	Dist. Chord to Center	4.589	or	4.589

<colgroup><col style="width:30px; "><col style="width:138px;"><col style="width:87px;"><col style="width:44px;"><col style="width:64px;"></colgroup><tbody>
</tbody>

Spreadsheet Formulas

Cell Formula B3 =2*($B$2*SIN(RADIANS($B$1)/2)) B4 =SQRT($B$2^2-($B$3/2)^2) D4 =B2*COS(RADIANS(B1/2)) <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

Works now - thanks so much - building complicated wood ribs for a 1.6 million dollar treehouse and we have 473 angles to assemble.