I am trying to add a formula on a worksheet in Calc. It is a complex formula, and I have tried all kinds of ways to enter it but none of them work - I always get an “invalid argument” error or something like that. It is the formula for calculating the volume of a substance (usually a liquid) in a tank (cylinder) of a certain radius and height.
Here is the formula (as I understand it)
L(R^2 cos-1 ((R-D)/R) - (R-D) sqrt(2RD-D^2)
where:
R is the radius of the cylinder.
D is the depth.
L is the length of the cylinder
That is the best I can do on the formula, as this text editor doesn’t have some ways (that I can see) to express some things in the formula (squared, square root, cos-1 is actually cos^-1 [I think], etc). I hope it is not forbidden to post links to something in a question post, I am going to have to hope it isn’t — so that anyone reading this that might know how to set up this formula can look at it and give me some help.
link text.
I knew that R D and L would have to have their own cells, and did that. I thought maybe cos needed to be worked separately in it’s own cell, so I did that. And I figured maybe the square root would need to be done in it’s own cell so I did that. Still no luck. Always get the error. Any help that someone could give me on this would be greatly appreciated. Thanks!