Solved

Excel model to find distance from XY points to a cirle

Posted on 2013-06-18
4
516 Views
Last Modified: 2013-06-18
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
Comment
Question by:NielsMadsen
  • 2
  • 2
4 Comments
 
LVL 81

Expert Comment

by:zorvek (Kevin Jones)
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

by:NielsMadsen
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

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

Kevin
0
 

Author Closing Comment

by:NielsMadsen
ID: 39255677
Precise, quick...GREAT
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question