Solved

# Excel model to find distance from XY points to a cirle

Posted on 2013-06-18
509 Views
I need an Excel model / functions to calculate distance from a number of points to a given circle.

I have a circle with a center xy and a given radius.
I have a list of points.
I need to know the closest distance from each point to the circle

The Excel model is attached - only thing missing is the calculation of the distance.
Points-distance-to-a-circle.xlsx
0
• 2
• 2

LVL 81

Expert Comment

ID: 39255521
Place this formula in E9 and copy down:

=((C9-\$C\$5)^2+(D9-\$D\$5)^2)^0.5-\$C\$2

Kevin
0

Author Comment

ID: 39255618
Excellent!

Is there a way to tell if the point is inside or outside the circle?
(is that the negative/positive distance?)

Niels
0

LVL 81

Accepted Solution

zorvek (Kevin Jones) earned 500 total points
ID: 39255650
Yes.

Kevin
0

Author Closing Comment

ID: 39255677
Precise, quick...GREAT
0

## Featured Post

### Suggested Solutions

Prime numbers are natural numbers greater than 1 that have only two divisors (the number itself and 1). By “divisible” we mean dividend % divisor = 0 (% indicates MODULAR. It gives the reminder of a division operation). We’ll follow multiple approac…
We are taking giant steps in technological advances in the field of wireless telephony. At just 10 years since the advent of smartphones, it is crucial to examine the benefits and disadvantages that have been report to us.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.