Quote Originally Posted by Aussiebear View Post
The midpoint of half circle HC1 will sit somewhere on the horizontal leg providing the arc is always contained within the Area of the Quadrant.
1. For the purpose of this exercise, the radius of the HC1 just happens to be 3m which puts it at the midpoint of the Quadrant horizontal radius.
<snip>
Thus the area remaining in the quadrant is 28.27433388 - 14.13716694 - 6.283185306. = 7.853981634 sq mtrs.

Since we are having difficulty in creating a Function, can somebody confirm that my maths is correct and is there a way to write to correct formulas into excel. Once I'm able to move past this point then I shall concentrate on a Function to do the same thing.
I can only say yes, your maths is correct because it agrees with my results.
Because of the size constraint of HC1 then my function in msg#4 holds, because all that maths reduces to that simple equation, no matter what the size of the quadrant.
Test it with values other than 6
2025-07-04_141849.jpg