A thought,

I've assumed a round tank!! if it's rectangular use

=(L*B*A1)*6.22883288

Where L * B are the 2 sides
A1 remains the same

Mike

"Mike H" wrote:

Scotty,

Use this formula

=(PI()*B1^2*A1)*6.22883288

Where
B1 is the radius of the tank
and
A1 is the dip depth in inches
the answer will be imperial gallons

Mike

"Scotty" wrote:

I have a tank that I measure daily to see how many gallons are in. I measure
it with a stick and then look at a chart made for the tank to see how many
gallons it equals. I would like to set up excel so that I can enter in the
stick measurement and it will give me the gallons in the next column
automatically. Any suggestions on how to do this?