answersLogoWhite

0


Best Answer

You just need to multiply the width by the length by the depth. Having done that, it will depend on what units you are using for the size and what units you are trying to get the volume in, as to what you do next. You would need to check up the various conversion calculations in order to do that. If the width was in A2, the length in B2 and the depth in C2, then your initial formula will be:

=A2 * B2 * D2

Using that result you will need another formula to get it to the units you need.

User Avatar

Wiki User

9y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: Formula to calculate volume tank in Excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is formula for calculate volume of round tank in liters?

diamater 1300 x Hight 1800. what is the volume in litres


How do you measure capacity of a tank?

The answer depends on whether or not the tank has a geometric shape. If it has a shape that can be broken up into simply geometric shapes, each with a volume formula, you can calculate the volume of each section and add them together. Obviously that will not work with a random shape. In that case, you can fill the tank to capacity and then empty it out into measuring jars or flasks. Use the volume of the jars to calculate the volume of the tank.


What is the formula to work out the volume of a water tank?

It depends on the shape of the tank.


How do you calculate the volume of the rectangular tank in terms of Kilogarm?

Kilogram is weight, not volume.


What formula should be used to calculate the number of gallons in a cylindrical water tank?

The formula to find the volume of a right cylinder is height times area of the circular base. This volume in cubic feet is then multiplied by 7.48 to find the number of gallons.


How many liters in 15ftx30ft high tank?

A liter is a measure of volume; we need to calculate the volume of the tank. For this we need to have all three measurements of the tank.


What is the formula for finding the volume of a irregular solid?

Eureka!There really isn't a "formula" for discovering the volume of an irregularly shaped solid. Instead, submerge the irregular solid in water and measure the volume of water it displaces to discover its volume. The ExperimentFor finding the volume of an irregular solid we just fully dip (submerge) it in a water tank which is fully filled with water and is attached to an another tank (a cylindrical overflow tank) through a pipe. With the setup in place, we put the solid into the full tank. The solid will displace water, which will flow through the pipe into the overflow tank. Further, the volume of the water the solid displaces will be equal to the volume of that irregular solid. Now we calculate the volume of water in the overflow tank using the depth of that water and the diameter of the tank. The volume of the displaced water will equal the volume of the irregularly shaped solid.There will generally not be a formula and the volume will have to be measured in some other way.


How do you calculate volume of rectangle tank 18x12x30?

To calculate the tank's volume, you would have to multiply its dimensions together. In this case, it will be 18 x 12 x 30, which is 6480 units cubed


How do you calculate the volume of a vertical cylinder tank?

Volume = Cross sectional Area x Height.


Calculate Volume of a Spherical tank?

A sphere volume = 4/3 pi r cubed


What is the formula tor calculating the liquid volume in a fish tank?

v=sh


Calculate volume of fuel sg83 to fill 720 liter tank?

The volume required to fill a 720-litre tank is going to be (720 litres) minus (amount in the tank before you began filling it)