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

<colgroup><col width="312"><col width="81"><col span="2" width="64"><col width="111"></colgroup><tbody>
[TD="width: 312, align: right"]90[/TD]
[TD="width: 81, align: right"]8[/TD]
[TD="width: 239, colspan: 3"] =2*B1*SIN(RADIANS(A1/2))[/TD]

</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
Angle
radius
Chord
Dist. Chord to Center

<colgroup><col style="width:30px; "><col style="width:138px;"><col style="width:87px;"><col style="width:44px;"><col style="width:64px;"></colgroup><tbody>
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]1[/TD]

[TD="align: right"]110[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]2[/TD]

[TD="align: right"]8[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]3[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: right"]13.106[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]4[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: right"]4.589[/TD]
[TD="align: center"]or[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: right"]4.589[/TD]

</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.