trig formula problem

[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???

 

[sulprobil]

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

 

[Skacey]

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))