How can i produce "tan to -1 " in excel ?
thanks
How can i produce "tan to -1 " in excel ?
thanks
isnt that the same as 1/tan ?
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
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
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
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
Using named ranges:
![]()
Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
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
How about posting a link to the source of the formula?
At constant deceleration, stopping time is linearly proportional to speed.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks