How to Use Excel as Area and Volume Calculator?

Get FREE Advanced Excel Exercises with Solutions!

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 PRODUCTPOWER, 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.

Overview image of Excel Area and Volume Calculator


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)

Rectangle


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

Calculating area of rectangle


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.

PRODUCT Function

 

  • 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)

Calculating area of rectangle


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)

Triangle

  • 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

Calculating area of triangle


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

Square

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

Calculating area of square using circumflex symbol

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.

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)

Calculating area of square using Power function


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

Trapezium

  • 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

Calculating area of trapezium


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 r2

Where,

r = Radius of the circle

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

Calculating area of circle


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 r3

Where,

r = Radius of the Sphere

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

Calculating volume of sphere


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)

Rectangular solid

  • 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)

Calculating volume of rectangular solid


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= a3

Where,

a = Length of the sides

Cube

  • 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

Calculating volume of cube


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 r2 x h

Where,

r = Radius of the Top & Bottom Surface

h = Height of the CylinderCylinder

  • 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

Calculating volume of cylinder


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 r2 x h

Where,

r = Radius of the Base of the Cone

h = Height of the Cone

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

Calculating volume of cone


6. Calculate Volume of Torus

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

Volume of a Torus = π x r2 x 2 x π x R

Where,

r = Inner Radius of the Torus

R = Outer Radius of the Torus

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

Calculating volume of torus


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

Ellipsoid

  • Range C4:C6 contains the values along X, Y and axes.
  • Select cell C7, apply the formula below and press Enter.
=(4/3)*PI()*C4*C5*C6

Calculating Volume of Ellipsoid


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 (m3) 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 m3


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

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Raiyan Zaman Adrey
Raiyan Zaman Adrey

Raiyan Zaman Adrey, armed with a BSc in Civil Engineering from Bangladesh University of Engineering and Technology, efficiently combines engineering skills with a passion for Excel. In his role as an Excel & VBA Content Developer at ExcelDemy, he not only tackles complex issues but also demonstrates an enthusiastic mindset, efficiently managing critical situations with patience, showcasing his commitment to excellence. He is interested in C, C++, C#, JavaScript, Python, Microsoft Office, AutoCAD, Adobe Illustrator, Data Entry, and... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo