Function help needed

  • Thread starter Thread starter Andrew
  • Start date Start date
A

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!!
 
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
 
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!!
Click to expand...

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
 
Back
Top