| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compass degrees formatting
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Compass degrees formatting
I assume you meant "005 rather than 365", and not "005 rather than 345"?
Try =MOD(A1+B1,360) -- David Biddulph "Stephen" wrote in message ... 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you convert decimal degrees to degrees minutes seconds | Excel Discussion (Misc queries) | |||
| how can i convert degrees/minutes/seconds to decimal degrees? | Excel Discussion (Misc queries) | |||
| calculate from degrees to degrees/minutes/seconds on excel? | Excel Worksheet Functions | |||
| convert decimal degrees to degrees minutes seconds | Excel Discussion (Misc queries) | |||
| converting from digital degrees to degrees minutes seconds | Excel Worksheet Functions | |||
Linear Mode
