View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default Use of cosinus for calculation of a triangle

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