Thread: [Solved] the angle format (º ‘ ‘’) and calculation?
View Single Post
 
Old 04-25-2012, 03:57 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,375
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
Hi Jamal,
The formula in H4 can be reduced to:
=MOD(H3+C4+7.5,15)
You can then copy this down to H8.

BTW, you really should correct the basic angles. Surely the sum in C9 should be exactly 540º00'00''?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote