what is command for instead DEGREES(ATAN2(A2,B2)) formula in excel??

8 visualizaciones (últimos 30 días)
galaxy
galaxy el 3 de Jun. de 2022
Comentada: galaxy el 8 de Jun. de 2022
Dear all !!!
I tried to change formula from excel file to matlab function. But result didnot same as figure.
Can anyone help me to explain and fix it?
Thank you
  6 comentarios
David Goodmanson
David Goodmanson el 4 de Jun. de 2022
Hi galaxy,
exactly how, in what environment, are those values of -179... being calculated? Certainly if you import the values of E and N into Matlab, you get +179... as you should.
galaxy
galaxy el 8 de Jun. de 2022
Thank you for your answers.
I don't know why, but I tried in Matlab ver 2019b, it had right value, 179.
Maybe I was wrong. I will detele this question, sorry for the inconvenience.

Iniciar sesión para comentar.

Respuestas (1)

Benjamin Thompson
Benjamin Thompson el 4 de Jun. de 2022
Since -179 and 179 degrees are very nearly equal, those results are actually within the tolerance of your other results. If you used the wrong sign on the "N" component this would explain it, and just keep in mind when very small number and very large numbers are used together in calculations this can lead to odd results. Also is the Excel screenshot showing any rounding, such that the calculations are using additional digits of precision that Excel is not displaying?

Categorías

Más información sobre Matrix Indexing en Help Center y File Exchange.

Etiquetas

Productos


Versión

R2019b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by