i am working on a compass worksheet in excel. i enter in starting and ending Longitude and latitudes and it calculates distance. i have calculated the percent of 90 deg now i just need to put it in the right quadrant.
If Lat1 > 0 and if Lon1 >0 then Percent * 90 If Lat1 < 0 and If Lon1>0 then Percent * 90 +90
If Lat1 < 0 and if Lon1 <0 then Percent *90+180 If Lat1 > 0 and if Lon1 <0 then Percent *90+270
returned value
variables
Lat1
Lon1
Percent
thanks for taking a look!!
john
If Lat1 > 0 and if Lon1 >0 then Percent * 90 If Lat1 < 0 and If Lon1>0 then Percent * 90 +90
If Lat1 < 0 and if Lon1 <0 then Percent *90+180 If Lat1 > 0 and if Lon1 <0 then Percent *90+270
returned value
variables
Lat1
Lon1
Percent
thanks for taking a look!!
john