Excel quessie, inverse Tan?

[Jezz_S13]

Any idea?

I've making a spread sheet of cambers for my car so I don't ahve to keep working it out but i cant find a function that will find the inverse tan of a number.

Theres tan that gives the tangent of an angle but i want to go the other way, tangent to angle. Anyone know??? :cry:

[Mark]

use ATAN :thumbs:

[Jezz_S13]

doesn't seem to work. :(

It jsut spits out the same number (almost) as I put in. :confused:

eg ATAN(0.025) = 0.02499

where tan-1 (0.025) is 1.4deg.

Or is this a radians/degrees thing?

[Mark]

think you will find it converts it to rads so need to change it to deg

[Jezz_S13]

so to change to degrees i do what?

2 x pi radians in a circle yeah?
so (my answer/(2 x pi)) * 360?

Yay it works, cheers. :)

I'm too old for all this maths bollarks.

[Mark]

;) :thumbs: :clap:

[Ally McC]

Is there anyone else who understood that :eek:

:D

[Aitch]

Is there anyone else who understood that :eek:

:D
Yep, every word.






























:no: Not really. :wack:

[disco-tom]

http://www.notsosketchy.com/geeks.jpg


:D :p

[Aitch]

http://www.notsosketchy.com/geeks.jpg


:D :p
LMAO :notworthy

[Ally McC]

NIce one disco-tom :D :D

[Jezz_S13]

You lot should have gone to school. :nod: :p :D :D