# How to Calculate the Volume of a Sphere with Microsoft Excel

Written by jason artman
• Share
• Tweet
• Share
• Email

Although calculators simplify many aspects of mathematics, it can be cumbersome to enter formulas repeatedly such as the formula for the volume of a sphere, which is the product of 4/3, Pi and the cube of the sphere's radius. Using a spreadsheet program such as Microsoft Excel, you can enter this formula a single time. Excel then calculates the volume of a sphere automatically when you type the measurement of its radius.

Skill level:
Moderately Easy

## Instructions

1. 1

Place the cursor in cell A1 of a blank spreadsheet. This is the cell in the upper-left corner of the spreadsheet. Type "Radius" and press "Enter" to drop to cell A2 below.

2. 2

Type "Volume" in cell A2, then press the right-arrow key to move to cell B2.

3. 3

Type "=4/3Pi()B1^3" without quotation marks in cell B2. This formula tells cell B2 to display the volume of a sphere when the radius of the sphere is typed in cell B1.

4. 4

Type the radius of the sphere in cell B1 to display the volume in cell B2.

### Don't Miss

• All types
• Articles
• Slideshows
• Videos
##### Sort:
• Most relevant
• Most popular
• Most recent