M
mahadevan.swamy
Hi,
I have two circles. I have the co-ordinates and radius of the first
circle and the second circle. The condition that should be checked is,
if the co-ordinates of the second circle is in the range of the first
circles, then it should assign a value (0, 1, or X) based on the
condition.
For example, the co-ordinates and radius of the first circle is (x,y,
r) = (1.080, 3.520, 0.062) and for the second circle, it is (x,y, r) =
(0.922, 3.4411, 0.295). I want to check if the second circle is in the
range on the first circle and if it is in the range, the value should
be 0. If the second circle is out of range, the value should be 1. If
the second circle is blocking the first circle or very closely
touching the first circle, the value should be X. The answer to the
proposed problem should be 0 as I have a picture.
Are there any co-ordinate functions in excel? I would appreciate if
anyone can help me to build a good formula for this problem. Thanks
I have two circles. I have the co-ordinates and radius of the first
circle and the second circle. The condition that should be checked is,
if the co-ordinates of the second circle is in the range of the first
circles, then it should assign a value (0, 1, or X) based on the
condition.
For example, the co-ordinates and radius of the first circle is (x,y,
r) = (1.080, 3.520, 0.062) and for the second circle, it is (x,y, r) =
(0.922, 3.4411, 0.295). I want to check if the second circle is in the
range on the first circle and if it is in the range, the value should
be 0. If the second circle is out of range, the value should be 1. If
the second circle is blocking the first circle or very closely
touching the first circle, the value should be X. The answer to the
proposed problem should be 0 as I have a picture.
Are there any co-ordinate functions in excel? I would appreciate if
anyone can help me to build a good formula for this problem. Thanks