• Welcome to MacSailing.net!
  • Dedicated to sailing!
  • Be Jolly!
Hello There, Guest! Login Register

MacSailing.net > MacSailing.net > MacENC & GPSNavX > GPSBable >

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Title: GPSBable
Offline
Jade
5


******
Posts: 769
Threads: 15
Joined: May 14, 2005
Reputation: 4
#6
February 11, 2010 06:35
If you don't use Excel often, remember that you can apply the formula to the entire column by selecting the column containing the formula in the top cell and choosing Edit>Fill>Down.

I should also change the column/cell to B1 instead of A2 in the longitude formula:

=(LEFT(B1,3)*1+MID(B1,6,6 )/60)*IF(RIGHT(B1,1) = "E",1,-1
— —•••  •••— —
 Jon Longworth

 
Reply
  


Messages In This Thread
[No subject] - by - February 8, 2010 09:09
[No subject] - by - February 8, 2010 09:14
[No subject] - by - February 9, 2010 20:30
[No subject] - by - February 10, 2010 08:14
[No subject] - by - February 10, 2010 20:21
[No subject] - by - February 11, 2010 06:35
[No subject] - by - February 24, 2010 16:47
[No subject] - by - March 4, 2010 09:29
[No subject] - by - March 4, 2010 12:14
[No subject] - by - March 5, 2010 07:56

Forum Jump:


Browsing: 3 Guest(s)