Forum Discussion
Area of a Circular Segment given its height in Excel
Hi All,
I'm having a real problem trying to input the below formula into excel. I'm trying to calculate the area of a circular segment with only the radius or a circle, total area and offset fr...
Hi! I just had the same problem from trying to calculate the fill percentage of a tank, givet its water level.
Solved it when I realized that COS^-1 is the same as ARCCOS, which is the formula that Excel uses.
So, here is the Excel formula:
=r^2*ARCCOS((r-h)/r)-(r-h)*SQRT(2*r*h-h^2)
I had:
=$B$3^2*ARCCOS(($B$3-$B$4)/$B$3)-($B$3-$B$4)*SQRT(2*$B$3*$B$4-$B$4^2)
and of course the radius in cell B3 and the height i cell B4.
Hope this helps!