Forum Discussion

Kane Hollstein's avatar
Kane Hollstein
Copper Contributor
Apr 03, 2018

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 from the centre to a variable point of measurement.

 



Hopefully, somebody can help?!

Formulas & Functions
training
  • Erik T Larsson's avatar
    Erik T Larsson
    Copper Contributor
    Jul 12, 2018

    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!

Resources