Excel Calculate the wrong results
Goodday to you all.
I am currently taking my Navigational Excams and am trying to make a Excal sheet that can do the calculations for me, but for some reason it does it wrong, I get the wrong results, and was wondering what I have done wrong. I have added the sheet to this tread, hope someone can help me. The formular that is calculating wrong is this one
=ACOS((SIN(G12)-SIN(G11)*COS(L20))/(COS(G11)*SIN(L20)))
Best regards
Allan Sørensen
| Attachment | Size |
|---|---|
| Navigations udregninger.xlsx | 17.63 KB |
break it
break it down:
=ACOS((SIN(0.799942573830734)-SIN(1.02974425867665)*COS(0.600355207769143))/(COS(1.02974425867665)*SIN(0.600355207769143)))
goes to:
=ACOS((0.717316080519289-0.85716730070211*0.825134997453205)/(0.515038074910058*0.564935603390244))
goes to:
=ACOS((0.717316080519289-0.707278738481806)/(0.290963345618263))
goes to:
=ACOS(0.0344969295570713)
=1.53629255146079
why do you think Excel is wrong ?