Function help needed

[Andrew]

Trying to work out the following formula:

Theta = (span = 1160) / (2 * Rad = 797.8) INV SIN * 2

When doing this on a calculator the answer is 93 degrees.

Need to put this formula in as a cell function. I have
tried to use ASIN and ASINH but to no avail.

PLEASE HELP!!

 

[JE McGimpsey]

One way:

=DEGREES(ASIN(1160/(2*797.8))*2) ====> 93.27083355

 

[Jerry W. Lewis]

Excel's trig functions work in radians, not degrees, but there are
conversion functions. I believe that you want
=DEGREES(ASIN(span/(2*rad)))*2
When span=116 and rad=797.8, the result is 93.27

I have difficulty imagining a more confusing way to have presented your
equation.

Jerry

 

[Ron Rosenfeld]

Trying to work out the following formula:

Theta = (span = 1160) / (2 * Rad = 797.8) INV SIN * 2

When doing this on a calculator the answer is 93 degrees.

Need to put this formula in as a cell function. I have
tried to use ASIN and ASINH but to no avail.

PLEASE HELP!!

Excel refers to all angles in radians. So your formula would translate:

=DEGREES(ASIN(span/(2*rad))*2)

for Theta in Degrees.

I get 93.27083355° using your values


--ron