Find the distance between each Point 1 and the static Point

Find the distance between each Point 1 and the static Point 2 using Pythagoras\' theorem. Write this formula using Excel functions and cell references in cell G21. Then use the fill handle to extend the formula to calculate distances between each point pairs. Display each distance with to two decimal places. Use Conditional Formatting to show data^-s for the distances.

Solution

G21=SQRT((D21-A21)*(D21-A21) +(B21-E21)*(B21-E21))

G22=SQRT((D21-A22)*(D21-A22) +(B22-E21)*(B22-E21))

G23==SQRT((D21-A23)*(D21-A23) +(B23-E21)*(B23-E21))

and so on D21 and E21 are constants

Point 1            Point 2 Distance between Points              X              Y             X             Y 2 26 26 16 26.00 21 9 8.60 18 13 8.54 3 15 23.02 18 17 8.06 24 4 12.17 25 25 9.06 15 8 13.60 28 9 7.28 8 11 18.68 10 22 17.09 15 8 13.60 6 23 21.19 18 10 10.00 10 2 21.26 13 5 17.03