I am trying to round latitude and longitude from 4 significant digits of precision to 1. The database contains lat/long formatted in DMS, like this:
41 43 49.5130 -122 32 44.0820
To bring it into the software I am working in, it needs to be formatted with only one degree of precision like this:
41 43 49.6 -122 32 44.1
I am super new at Excel -but have perused the topics all weekend- so I am at a loss as to how to create a function to do this. In my scribblings, I came up with if(d2,13)>=5then(d2,12)+1 (working on the longitude) but I know that's not the formula, it just, in a rudimentary way explains what I would like to do.
41 43 49.5130 -122 32 44.0820
To bring it into the software I am working in, it needs to be formatted with only one degree of precision like this:
41 43 49.6 -122 32 44.1
I am super new at Excel -but have perused the topics all weekend- so I am at a loss as to how to create a function to do this. In my scribblings, I came up with if(d2,13)>=5then(d2,12)+1 (working on the longitude) but I know that's not the formula, it just, in a rudimentary way explains what I would like to do.