Transform angle to 0 - 360°
Hello all,
I have cell that contains an angle in degrees. Let's day 2871°. Now I need the equivalent angle of this between 0 and 360°, so in this case that would be 351°. What would be the easiest way to accomplish this? Be aware that this should work automatic for any angle, even a negative one. I would like to do this with a function in excel and not with VBA.
Any ideas?
Kind regards,
Gert
Hi,
=MOD(A1,360)
Regards
Change the reference to cell A1 as necessary.
Formula:
Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Thank you so much!Originally Posted by XOR LX
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks