Compass degrees formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I format cells so that if I add say 10 degrees to a compass value of
355, Excel will return 005 rather than 345; in other words I want to work in
base 360.
 
I assume you meant "005 rather than 365", and not "005 rather than 345"?

Try =MOD(A1+B1,360)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Compass angles in Excel 10
Coding data 2
How do I express numbers with compass degree symbols? 4
How to determine the closest degree? 2
Calculating in degrees only 1
rotate picture based on cell value 6
How do I chart wind direction and velocity on a radial plot? 0
IF and OR functions 5

Back
Top