In this Excel tutorial, you will learn

-The basics of Excel area and volume calculator.

-The calculation of the area of various 2D geometric shapes.

-The computation of the volume for several common 3D objects.

-Use of **PRODUCT**,Â **POWER**, andÂ **PIÂ **functions to calculate area and volume of several geometric shapes.

We have used Microsoft 365 while preparing this article but the methods mentioned in this article are also applicable in all Microsoft versions.

Calculating area and volume of different shapes is often essential in the field of mathematics, geometry, engineering, architecture, physics, and others. Excel area and volume calculator is such a feature that has the ability to measure these values precisely and quickly.

**Download Practice Workbook**

## How to Calculate Area in Excel?

In this section, you will learn the calculations of areas of different two-dimensional (2D) geometrical shapes in Excel.

### 1. Calculate Area of Rectangle

The quadrilateral whose opposite sides are equal and parallel and all the internal angles are right angles is called a rectangle.

**Area of Rectangle = Length (l) x Width (w)**

**1.1 Using Asterisk (*) Symbol**

We can calculate the area of a rectangle in Excel using the **asterisk** (*****) symbol.

- In the following dataset, length and width are given in cell
**C4**and cell**C5Â**respectively. - Select cell
**C6**and apply the formula below then press**Enter**.

`=C4*C5`

**1.2 Using PRODUCT Function**

**The PRODUCT function** calculates the product of values from a range. The function multiplies all the numbers given as arguments.Â Let’s have a look at the brief overview of theÂ **PRODUCT** function in the following image.

- We will now learn how to use this formula to calculate the area of a rectangle in Excel.
- Select cell
**C6.** - Then insert the formula below and hit
**Enter**.

`=PRODUCT(C4:C5)`

### 2. Calculate Area of Triangle

A triangle is a polygon with three sides and three vertices.

**Area of Triangle = (Â½) x Base (b) x Height (h)**

- You are given the values of the base and height of a triangle in cell
**C4**and cell**C5Â**respectively. - Select cell
**C6**, then copy and paste the formula below and press**Enter**.

`=0.5*C4*C5`

### 3. Calculate Area of Square

A square is a type of quadrilateral which has equal sides, opposite sides are parallel and all the angles are right angles.

**Area of Square = (Length of side) ^{2}**

**3.1 Using Circumflex(^) Symbol**

You can calculate the area of a square in Excel using the **Circumflex** (**^**) symbol.

- Letâ€™s presume, you have the length of the side of a square in cell
**C4**. - Select cell
**C5**, apply the below formula and hit**Enter**.

`=C4^2`

**3.2 Using POWER Function**

You can use **the POWER function** to calculate the area of a square as well. Let’s have a look at the overview of theÂ **POWERÂ **function.

- Now, we will show you how to use this function to calculate the area of a square in Excel.
- Select cell
**C5**and insert the formula below and press**Enter**.

`=POWER(C4,2)`

### 4. Calculate Area of Trapezium

A trapezium is a kind of rectangle whose two opposite sides are parallel but not equal. Let’s say, you have a trapezium whose length of two opposite and parallel sides are **a** and **b**. And the longitudinal distance between these two parallel sides is **h**.

**Area of Trapezium = (Â½) x (a+b) x h**

- Suppose, you have the value of side
**a**in cell**C4**and the value of side**b**in cell**C5**. The value height (**h)**is in cell**C6**. - Select cell
**C7**, insert the formula below and press**Enter**.

`=0.5*(C4+C5)*C6`

### 5. Calculate Area of Circle

A circle is a **2D** shaped figure that consists of all points in a plane that are equidistant from a fixed center point.

**Area of Circle = Ï€ x r ^{2}**

Where,

**r** = Radius of the circle

- Assume, you have the value of the radius of a circle in cell
**C4**. - Select cell
**C5**, insert the formula below and press**Enter**.

`=PI()*C4^2`

## How to Calculate Volume in Excel?

In this section, you will learn the calculations of volume for different three dimensional (3D) geometrical shapes in Excel.

### 1. Calculate Volume of Sphere

A sphere is a fully symmetrical three-dimensional object in which all points on its surface have equal distances from its center.

**Volume of Sphere =Â 4/3 x Ï€ x r ^{3}**

Where,

**r** = Radius of the Sphere

- Suppose, you have the value of the radius of a sphere in cell
**C4**. - Select cell
**C5**, type the formula below and press**Enter**.

`=(4/3)*PI()*C4^3`

### 2. Calculate Volume of Rectangular Solid

A rectangular solid is a three-dimensional shape with six parallel, equal-sized rectangles on each face.

**Volume of Rectangle= Length (l) x Width (w) x Height (h)**

- In the following dataset, you have the values of length, width and height of a rectangular solid in cells
**C4**,**C5**, and**Â C6Â**respectively. - Select cell
**C7**, insert the formula below and hit**Enter**.

`=PRODUCT(C4:C5)`

### 3. Calculate Volume of Cube

A cube is a parallelogram all of whose angles are right angles and all the sides are equal in length.

**Volume of Cube= a ^{3}**

Where,

**a** = Length of the sides

- Letâ€™s say, you have your value of the side length of a cube in cell
**C4**. - Select cell
**C5**, insert the formula below and hit**Enter**.

`=C4^3`

### 4. Calculate Volume of Cylinder

A cylinder is actually a solid geometrical figure with a circular or oval cross-section and straight parallel sides.

**Volume of a Cylinder = Ï€ x r ^{2} x h**

Where,

**r** = Radius of the Top & Bottom Surface

**h** = Height of the Cylinder

- You have the value of radius and height in cell
**C4**and in cell**C5Â**respectively. - Pick cell
**C6**, insert the below formula and press**Enter**.

`=PI()*C4^2*C5`

### 5. Calculate Volume of Cone

A cone is a solid or hollow object which has a circular base and an apex.

**Volume of a Cone =Â 1/3 x Ï€Â x r ^{2} x h**

Where,

**r** = Radius of the Base of the Cone

**h** = Height of the Cone

- Here, the radius of the base is given in cell
**C4**and the height in cell**C5**. - Select cell
**C6**, apply the formula below and press**Enter**.

`=(â…“)*PI()*C4^2*C5`

### 6. Calculate Volume of Torus

Torus is a large convex molding with a semicircular cross-section.

**Volume of a Torus = Ï€ x r ^{2} x 2 x Ï€ x R**

Where,

**r** = Inner Radius of the Torus

**R** = Outer Radius of the Torus

- Assume, the value of the inner radius is in cell
**C4**and the value of the outer radius is in cell**C5**. - Select cell
**C6**, insert the formula below and press**Enter**.

`=PI()*C4^2*2*PI()*C5`

### 7. Calculate Volume of Ellipsoid

The ellipsoid represents a three-dimensional figure which is symmetrical with all three axes. Its plane sections normal to one axis are circles and all the other plane sections are ellipses.

**Volume of Ellipsoid =Â 4/3 x Ï€ x X x Y x Z**

Where,

**X** = Value along X-axis

**Y**=Â Value along Y-axis

**Z**=Â Value along Z-axis

- Range
**C4:C6**contains the values along**X**,**Y**and**ZÂ**axes. - Select cell
**C7**, apply the formula below and press**Enter**.

`=(4/3)*PI()*C4*C5*C6`

## Frequently Asked Questions

**1. Is volume equal to surface area?**

No. The surface area is a two-dimensional measurement. On the other hand, volume is a three-dimensional one. The surface area indicates how much area the surface occupies and volume indicates the amount of space the object occupies.

**2. ****Can we convert area to volume?**

Yes, we can. However, the calculation depends on the shape. For example, let’s take a cubic shaped box. You can get the volume of it from the cross-sectional area by multiplying the height with the area.

**3. ****What is m3 formula?**

**m3** (**m ^{3}**) indicates a meter cube (meter to the power 3). It is the unit of volume.

Like, if I say the length, width and height of a rectangular solid are **10m**, **5m**, and **5m **respectively then the volume of that rectangular solid will be:

**length*width*height**

**=10*5*5**

**=250 m ^{3}**

## Conclusion

To utilize the Excel area and volume calculator, you just need to know the fundamental formulas. This article illustrates several 2D-shaped objectâ€™s area calculations in Excel. You will also find the calculations of some general 3D shaped objectâ€™s volume from the article.

Hope, you got whatever you were looking for. Visit our site **ExcelDemy** to explore more related articles.

## Excel Area and Volume Calculator: Knowledge Hub

**<< Go Back toÂ Excel Templates**