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!