So, as a part of a larger excel 'program' I'm writing, I need a formula that will let Excel find the intersection of two circles when given their radii and the x and y coordinates of the center. It does not have to check for an intersection--in the range I'm using it for, they will always intersect. Also, they will always intersect at two points.
Any ideas? The best sources I've found on the web are:
http://local.wasp.uwa.edu.au/~pbourke/geometry/2circle/
and
http://www.sonoma.edu/users/w/wilson...s/default.html
but neither of them seem to lend themselves handily to easy translation into a single cell (or small set of cells) in Excel. Ideally I want this to be something nice and concise, so that I can automate finding these intersections with large sets of data, as a part of an optimization exercise.
TIA, any help is appreciated
