Calculating the volume liquid in part of a cylinder

[Wright4d]

Hi

New here so was wondering if anyone can help me with a formula I have now had to start using regularly. It's a bit beyond my excel capabilities. It is for calculating the volume liquid in part of a cylinder lying on its side

Where R is the cylinder radius
D is the depth of liquid
L is the horizontal length of the cylinder

The cos-1 is in radians


Volume = L(R2cos-1(R-D/R)-(R-D)Root 2RD-D2)

I can't get a square root symbol and squared on here but I am sure you will all know what I mean

Thanks
Derek

 

[AlanY]

^0.5 should do it

 

[AlanY]

apology didn't read your post properly, try this

Excel 2013/2016
	A	B	C	D
1	R	D	L	V
2	10	15	50	12637
Sheet9

Cell Formulas
Range	Formula
D2	=C2*(A2^2*ACOS((A2-B2)/A2)-(A2-B2)*(2*A2*B2-B2^2)^0.5)

 

[Wright4d]

That's fantastic thank very much

 

[AlanY]

you're welcome