trig formula problem

  • Thread starter Thread starter RUSS
  • Start date Start date
R

RUSS

I am creating a workbook to perform the functions I need for traffic
accident reconstruction. I have come to a problem creating a formula.

I need the find something denoted as TAN-1 of .500 this is supposed to equal
26.56 degrees.

The "-1" is in superscript as though it is an exponent.

Can anyone help me please???
 
Yes:

=ATAN(0.5)*180/PI()

will result in your 26.56 degrees.

ATAN (arcus tangens) is the inverse function of TAN. See
excel help for more info.

HTH,
sulprobil
 
You're looking for the inverse of TAN which is ATAN. The results are in
radians so need to be converted to degrees. Thus:

26.56505=degrees(atan(0.5))
 
Back
Top