PC Review


Reply
Thread Tools Rate Thread

Compass degrees formatting

 
 
=?Utf-8?B?U3RlcGhlbg==?=
Guest
Posts: n/a
 
      23rd Sep 2007
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.
 
Reply With Quote
 
 
 
 
David Biddulph
Guest
Posts: n/a
 
      23rd Sep 2007
I assume you meant "005 rather than 365", and not "005 rather than 345"?

Try =MOD(A1+B1,360)
--
David Biddulph

"Stephen" <(E-Mail Removed)> wrote in message
news:2569D08B-BD79-43D7-A7A0-(E-Mail Removed)...
> 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.



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Converting Decimal Degrees to Degrees/Minutes/Seconds Larry_Klotz Microsoft Excel Worksheet Functions 1 2nd Nov 2009 07:22 PM
Formatting cells as degrees? Nigel Molesworth Microsoft Excel Discussion 1 4th Jun 2007 09:58 AM
Formatting for Degrees Minutes and Seconds geofferrington@hotmail.com Microsoft Excel Programming 2 27th Sep 2005 07:14 AM
How can I convert degrees minutes seconds to decimal degrees =?Utf-8?B?SGVpZGk=?= Microsoft Excel Worksheet Functions 1 23rd Sep 2004 02:55 PM
Formatting Cells to Show Numbers as Degrees? angelaj@pubpress.com Microsoft Excel Misc 4 4th Mar 2004 08:23 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:19 AM.