About Us

Whuggy

Thanks a lot for the answer. Just what I needed!

"Bernie Deitrick" wrote:

Whuggy,

With a in A2, b in B2, and c in C2, the value of C in degrees is

=ACOS((A2^2+B2^2-C2^2)/(2*A2*B2))*180/(PI())

and in radians is

=ACOS((A2^2+B2^2-C2^2)/(2*A2*B2))

HTH,
Bernie
MS Excel MVP

"Whuggy" wrote in message
...
Hello,
I'm having a problem getting excel to calculate the angles of a triangle.

I know the formula for calculating angle C for instance (knowing lengths
of
all three sides)

cosinus^-1 of (a^2+b^2-c^2)/(2*a*b)

But how do I put this into excel? When I put it in as following:
COS^1((a^2+b^2-c^2)/(2*a*b)) It dosn't work.

Can anybody help me?

Thanks

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Red triangle	weejb	Excel Worksheet Functions	1	March 12th 08 09:20 AM
What is blue triangle?	roccogrand	Excel Discussion (Misc queries)	2	December 24th 07 03:54 PM
Purple Triangle	aligatrjoe	Excel Discussion (Misc queries)	1	December 7th 07 05:37 PM
indicator triangle	Mail Merge labels for price	Charts and Charting in Excel	1	April 27th 06 05:27 PM
triangle chart	maryj	Charts and Charting in Excel	3	January 22nd 05 10:18 AM

Menu

About Us