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

Other People Are Reading

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

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

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.