cosine. I have a calculation that returns in cosine number, I want excel to look up the degree from this cosine number.
How?
.
two ways to screw up concrete 1) concrete driver 2) concrete finisher
Discussion Forum
Discussion Forum
Up Next
Video Shorts
Featured Story
We found the brightest, best-performing green laser in a head-to-head test of eight popular models.
Related Stories
Highlights
"I have learned so much thanks to the searchable articles on the FHB website. I can confidently say that I expect to be a life-long subscriber." - M.K.
Replies
Off the top of my head, I'd do it the two step way - acos() will give you the radians, then use degree() to convert that to degrees. But there's probably an easier way.
Check in Excel help for the ACOS function.
Returns the arccosine, or inverse cosine, of a number. The arccosine is the angle whose cosine is number. The returned angle is given in radians in the range 0 (zero) to pi.
Syntax
ACOS(number)
Number is the cosine of the angle you want and must be from -1 to 1.
Remark
If you want to convert the result from radians to degrees, multiply it by 180/PI() or use the DEGREES function.
Edited 1/12/2008 7:34 pm by Stuart
Check out the ACOS function.
Steve M.