Question: The previous conversion to decimal has ignored direction in column F . Let s revise our computation of the decimal degrees for the latitude and
The previous conversion to decimal has ignored direction in column F
Lets revise our computation of the decimal degrees for the latitude and longitude from the unsigned value to a signed value by multiplying the unsigned value with if the direction is North or East and if South or West. Place the signed angles into Column H Note the value for cell H should be the same as G
Hint: You will need to use at least if and OR statement.
What is the formula in cell H Copy and paste it as your answer.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
