[Solved] 360 degree problem

Discuss the spreadsheet application

[Solved] 360 degree problem

Postby marty-0750 » Wed Feb 05, 2020 4:14 pm

What is the IF THEN formulae to reduce angles that sum over 360 to within 360 deg?

Eg 275 + 108 = 383
if >360 then answer -360
383 - 360 = 23 deg

Martin
Last edited by robleyd on Thu Feb 06, 2020 8:00 am, edited 2 times in total.
Reason: Add green tick
OOo 4.0.1 on Ms Windows 7
marty-0750
 
Posts: 22
Joined: Tue Feb 17, 2009 5:01 am

Re: 360 degree problem

Postby Villeroy » Wed Feb 05, 2020 4:15 pm

=MOD(423;360)
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28573
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: [Solved] 360 degree problem

Postby marty-0750 » Thu Feb 06, 2020 4:56 am

Good one thanks!
OOo 4.0.1 on Ms Windows 7
marty-0750
 
Posts: 22
Joined: Tue Feb 17, 2009 5:01 am


Return to Calc

Who is online

Users browsing this forum: No registered users and 24 guests