Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tasos
 
Posts: n/a
Default Does anyone know, how can i write TAN^(-1) to the excel


  #2   Report Post  
Posted to microsoft.public.excel.misc
goober
 
Posts: n/a
Default Does anyone know, how can i write TAN^(-1) to the excel


To the best of my knowledge you can only take the tangent of a number to
a power not a power alone. Here is an example of a method I use to find
the tangent of 1 to the power -1.

=TAN(1)^(-1)

Hope it helps.


--
goober
------------------------------------------------------------------------
goober's Profile: http://www.excelforum.com/member.php...o&userid=19838
View this thread: http://www.excelforum.com/showthread...hreadid=499167

  #3   Report Post  
Posted to microsoft.public.excel.misc
Chip Pearson
 
Posts: n/a
Default Does anyone know, how can i write TAN^(-1) to the excel

Do you mean the arctangent? Use the ATAN function. Note that all
trig functions in Excel use Radians, not Degrees.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Tasos" wrote in message
...



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I write an Excel formula to calculate my working time? GregJ Excel Worksheet Functions 3 December 27th 05 01:48 PM
excel 4.0 macro removal tool Sachin Shah Excel Discussion (Misc queries) 0 August 25th 05 04:17 AM
How do I write an Excel formula that re-calculates every 24 hrs? heather Excel Discussion (Misc queries) 3 May 4th 05 10:58 AM
How to write IF function in Excel 2000 when there are two conditi. Dajana Excel Worksheet Functions 1 January 26th 05 02:15 PM
Difference in number of Excel NewsGroups Hari Prasadh Excel Discussion (Misc queries) 1 January 25th 05 11:32 AM


All times are GMT +1. The time now is 04:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"