Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 544
  • Last Modified:

Excel model to find distance from XY points to a cirle

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

Distance from circle
The Excel model is attached - only thing missing is the calculation of the distance.
Points-distance-to-a-circle.xlsx
0
NielsMadsen
Asked:
NielsMadsen
  • 2
  • 2
1 Solution
 
zorvek (Kevin Jones)ConsultantCommented:
Place this formula in E9 and copy down:

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

Kevin
0
 
NielsMadsenAuthor Commented:
Excellent!

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

Niels
0
 
zorvek (Kevin Jones)ConsultantCommented:
Yes.

Kevin
0
 
NielsMadsenAuthor Commented:
Precise, quick...GREAT
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now