+ Reply to Thread
Results 1 to 10 of 10

Tan to the power of minus 1

  1. #1
    Registered User
    Join Date
    12-10-2008
    Location
    UK
    Posts
    5

    Tan to the power of minus 1

    How can i produce "tan to -1 " in excel ?
    thanks

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320
    isnt that the same as 1/tan ?

  3. #3
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582
    Excel offers the ATAN function which gives the arctangent which is equal to Tan to the minus 1. Excel uses radians in trig functions so if you're working in degrees, multiply your number by pi first (Excel function Pi() ). Is that what you are looking for?
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  4. #4
    Forum Contributor
    Join Date
    08-21-2006
    Location
    Ossett, West Yorkshire
    MS-Off Ver
    2003
    Posts
    150
    Hi, if you had the tan of say 20° (0.363970234) and you want to return 20° then use the formula :=DEGREES(ATAN(0.363970234))

    Regards Howard

  5. #5
    Registered User
    Join Date
    12-10-2008
    Location
    UK
    Posts
    5
    the formula i am trying to reporduce is in the attachment,
    g= 127137.6
    m=500
    u=0.006
    k=20

    and v0 is a variable of velocity starting at 0 and going up in intervals of 10 up to 260.
    T is the value of time that i am trying to work out
    hope this explains what i am trying to do, thanks for your help
    Attached Images Attached Images

  6. #6
    Forum Contributor
    Join Date
    08-21-2006
    Location
    Ossett, West Yorkshire
    MS-Off Ver
    2003
    Posts
    150
    Hi
    =SQRT(DEGREES(ATAN(B8/(20*0.006*127137.6))))*SQRT(20/(0.006*127137.6*500))
    well thats how I read the formula which returns 0.00921 does that make any sense to you?
    regards Howard

  7. #7
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689
    Using named ranges:
    Please Login or Register  to view this content.
    Entia non sunt multiplicanda sine necessitate

  8. #8
    Registered User
    Join Date
    12-10-2008
    Location
    UK
    Posts
    5
    I dont think it has anything to do with degrees, because its to do with the amount of time a car takes to stop at different speeds, G is gravity, M is mass. so im not sure if degrees are involved thanks alot for the help though

  9. #9
    Registered User
    Join Date
    12-10-2008
    Location
    UK
    Posts
    5
    Quote Originally Posted by shg View Post
    Using named ranges:
    Please Login or Register  to view this content.
    The formula looks right but, they are supposed to be the time it takes to stop in seconds, and 0.196 seconds at 260km/h has to be wrong, so im not sure thanks anyway that formula was very useful

  10. #10
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689
    How about posting a link to the source of the formula?

    At constant deceleration, stopping time is linearly proportional to speed.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1