Hi team,

I’m trying to put a trig calculation into excel and am struggling to get the result I need. Here is an example of what I would do no a Non HP style calculator where you say 25 TAN as opposed to TAN 25.. (IE: The Microsoft Windows Calculator)

Where 25 is degrees.

25 TAN / 2 Sqrt = INV TAN

The answer is 18.248902383234398507193448623325

I want the 25 to bbe cell A:1

Can anyone assist on this please? I am not on constant interwebs connection so I will check back intermittantly when I find wifi.

Thank you in advance.

stan101 said:

Hi team,

I’m trying to put a trig calculation into excel and am struggling to get the result I need. Here is an example of what I would do no a Non HP style calculator where you say 25 TAN as opposed to TAN 25.. (IE: The Microsoft Windows Calculator)

Where 25 is degrees.

25 TAN / 2 Sqrt = INV TAN

The answer is 18.248902383234398507193448623325

I want the 25 to bbe cell A:1

Can anyone assist on this please? I am not on constant interwebs connection so I will check back intermittantly when I find wifi.

Thank you in advance.

=DEGREES)/(2^0.5)))

The Rev Dodgson said:

stan101 said:

Hi team,

I’m trying to put a trig calculation into excel and am struggling to get the result I need. Here is an example of what I would do no a Non HP style calculator where you say 25 TAN as opposed to TAN 25.. (IE: The Microsoft Windows Calculator)

Where 25 is degrees.

25 TAN / 2 Sqrt = INV TAN

The answer is 18.248902383234398507193448623325

I want the 25 to bbe cell A:1

Can anyone assist on this please? I am not on constant interwebs connection so I will check back intermittantly when I find wifi.

Thank you in advance.

=DEGREES)/(2^0.5)))

Hmm, not what I entered (press quote to see what it really says).

lets see if this works better:

=DEGREES)/Sqrt(2))

The Rev Dodgson said:

stan101 said:

Hi team,

I’m trying to put a trig calculation into excel and am struggling to get the result I need. Here is an example of what I would do no a Non HP style calculator where you say 25 TAN as opposed to TAN 25.. (IE: The Microsoft Windows Calculator)

Where 25 is degrees.

25 TAN / 2 Sqrt = INV TAN

The answer is 18.248902383234398507193448623325

I want the 25 to bbe cell A:1

Can anyone assist on this please? I am not on constant interwebs connection so I will check back intermittantly when I find wifi.

Thank you in advance.

=DEGREES)/(2^0.5)))

Thanks, Rev. One day I will have to buy you a few beverages of your choice! Work like a charm

cheers,

The Rev Dodgson said:

The Rev Dodgson said:

stan101 said:

Hi team,

I’m trying to put a trig calculation into excel and am struggling to get the result I need. Here is an example of what I would do no a Non HP style calculator where you say 25 TAN as opposed to TAN 25.. (IE: The Microsoft Windows Calculator)

Where 25 is degrees.

25 TAN / 2 Sqrt = INV TAN

The answer is 18.248902383234398507193448623325

I want the 25 to bbe cell A:1

Can anyone assist on this please? I am not on constant interwebs connection so I will check back intermittantly when I find wifi.

Thank you in advance.

=DEGREES)/(2^0.5)))

Hmm, not what I entered (press quote to see what it really says).

lets see if this works better:

=DEGREES)/Sqrt(2))

Can’t get it to display properly. Try pressing quote. Let me know if that doesn’t work.

stan101 said:

Thanks, Rev. One day I will have to buy you a few beverages of your choice! Work like a charm

cheers,

Glad it worked !