Hi,
I'm doing a bigger trigonometric calculation in excel and my answers are very strange in some cells.
I'm double checking them with my calculator and they do answers differently...
Let me try to sum it up,
Triangle: a=7, b=6, c=8, A=75,52', B=46,57', C=57,91'
I want to calculate the "a" on each side of the center line of angle C.
This gives me a easy calculation to give me a right triangle. C1=180-(90+75,52) = 14,48' & C2=180-(90+46,57) = 43,43'. checksum = 14,48+43,43 = C57,91
then to do pytagoras to calculate the new "a", i need to find the height of the new b/c: b = COS(14,48)*6 = 5,80 & c = COS(43,43)*8 = 5,80.
BUT in excel this gives me two different results on the same calculation.
=COS(DEGREES(H2))*B2 (gives me the correct result)
=COS(DEGREES(J2))*C2 (gives me wrong result)
excel file is attached pyta.xlsx
What am i doing wrong?
Bookmarks