Excel Formulas to Calculate the Volume of a Cylinder~ Easily!!
Tags: excelformula, excelformulas
Published: 2021-07-05 05:16:06

---
title: Excel Formulas to Calculate the Volume of a Cylinder~ Easily!!
published: true
date: 2021-06-29 05:52:15 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-calculate-the-volume-of-a-cylinder/
---

The  **volume of a cylinder**  is the **density** of the cylinder which signifies the amount of material it can carry or how much amount of any material can be immersed in it. In this chapter, we will show the formulas to **find out the volume of a cylinder in Excel**. Let’s jump into this article!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Volume of Cylinder](https://geekexcel.com/wp-content/uploads/2021/06/Volume-of-Cylinder.png)](https://geekexcel.com/excel-formulas-to-calculate-the-volume-of-a-cylinder/volume-of-cylinder/#main)<figcaption id="caption-attachment-48151">Volume of Cylinder</figcaption>

## Generic Formula:

- **Cylinder’s volume**  is given by the formula, **πr<sup>2</sup>h**.
- Here, **r** is the **radius** of the circular base and **h** is the **height** of the cylinder.
- To find out the volume of a cylinder in Excel, you can use the below formula.

**=[PI](https://geekexcel.com/how-to-use-excel-pi-function-in-office-365-with-examples/)()\*r^2\*h**

## Syntax Explanations:

- **PI**  – In Excel, the **[PI function](https://geekexcel.com/how-to-use-excel-pi-function-in-office-365-with-examples/)** helps to return the value of the constant π (3.14159265358979).
- **r** – It represents a radius.
- **h** – It specifies the height of the cylinder.
- **Multiplication (\*)** – In this symbol will multiply any two values or numbers.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.

## Practical Example:

Refer to the below example image.

- First, we will enter the input radius and height in **Column B** and **Column C**.
- Here we need to calculate the volume of a cylinder.

![Input Ranges](https://geekexcel.com/wp-content/uploads/2021/06/Input-Ranges-85.png)<figcaption id="caption-attachment-48149">Input Ranges</figcaption>

- Select any cell and type the above-given formula.

![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/06/Enter-the-formula-101.png)<figcaption id="caption-attachment-48148">Enter the formula</figcaption>

- Finally, press the ** ENTER**  key, you can get the result as shown below.

![Result](https://geekexcel.com/wp-content/uploads/2021/06/Result-86.png)<figcaption id="caption-attachment-48150">Result</figcaption>

## Conclusion:

From this chapter, you can get some clarification on how to find out the **volume of a cylinder in Excel**. Please feel free to state your **query** or **feedback** for the above article.

Thank you so much for visiting  **[Geek Excel](https://geekexcel.com/)!! **If you want to learn more helpful formulas, check out [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Read Also:

- **[Excel Formulas to Calculate the Area of a Circle ~ Simple Tutorial!!](https://geekexcel.com/excel-formulas-to-calculate-the-area-of-a-circle-simple-tutorial/)**
- **[How to Insert a Date or Formatted Date in Excel Office 365?](https://geekexcel.com/how-to-insert-a-date-or-formatted-date-in-excel-office-365/)**
- **[Create a Stacked Area Chart in Excel Office 365 &#8211; [Simple Steps]](https://geekexcel.com/create-a-stacked-area-chart-in-excel-office-365-simple-steps/)**
- **[Excel Formulas to Calculate the Area of a Trapezoid ~ Easy Tricks!!](https://geekexcel.com/excel-formulas-to-calculate-the-area-of-a-trapezoid/)**