Finding distance between multiple coordinates relative to a single coordinate

[GreatMacca]

So I have over 100 points that I need to find the distance to from a single Cartesian point. I was hoping someone out there could help me find a way to only have to put the coordinates in and have Excel work out the answers. I have done a little bit of work with Excel but am totally lost here. Thank you in advance.

 

[3PlankWalker]

<title>Excel Jeanie HTML</title>Hi, Try this

Sheet1

	A	B	C
1	X	Y
2	0	0	Origin
3	1	2	2.236068
4	2	-1	2.236068
5	3	6	6.708204
6	4	8	8.944272
7	-5	-10	11.18034
8	6	12	13.41641
9	7	14	15.65248
10	8	-16	17.88854

<tbody>
</tbody>

Formeln der Tabelle

Zelle Formel C3 =SQRT(($A$2-A3)^2+($B$2-B3)^2) C4 =SQRT(($A$2-A4)^2+($B$2-B4)^2) C5 =SQRT(($A$2-A5)^2+($B$2-B5)^2) C6 =SQRT(($A$2-A6)^2+($B$2-B6)^2) C7 =SQRT(($A$2-A7)^2+($B$2-B7)^2) C8 =SQRT(($A$2-A8)^2+($B$2-B8)^2) C9 =SQRT(($A$2-A9)^2+($B$2-B9)^2) C10 =SQRT(($A$2-A10)^2+($B$2-B10)^2) <tbody> </tbody>

<tbody>
</tbody>

Distance Between Two points = SQRT((X2-X1)^2+(Y2-Y1)^2)