Hi all,

As a total beginner with regard to Excel and sadly lacking in mathematical ability, I was seeking assistance in a problem I have been assigned.

Basically, I have been given the fixed coordinates (in eastings and northings) of one point and need to calculate the distance and bearing of a selection of other points relative to the fixed point.

For example, the fixed point - Point X = 100 E and 200 N and the other points are as follows:

Point A = 250 E and 100 N
Point B = 220 E and 320 N
Point C = 80 E and 450 N

Just wondering how I can use Excel to work out the distances from X to A,B & C respectively and the bearing expressed in degrees (i.e. between 0-360)?

I have been trying to use a combination of SIN,COS and TAN, but I just am not getting close to calculating any angles.

Any assistance on this is greatly appreciated.