Use the ^ Sign for Exponents

March 04, 2022 - by Bill Jelen

Problem: I have a room that is 10 feet x 10 feet x 10 feet. How do I find the volume of the cube?

Strategy: The formula for volume is width x length x height. In this case, it is 10 x 10 x 10, or 103. In Excel, the caret symbol (also known as “the little hat,” or “the symbol when you press Shift 6”) is used to indicate exponents. Here’s how you use it to find the volume of your room:

1. In cell B2, enter 10.
2. In cell B3, enter the formula =B2^3.

The result will be 1,000 cubic feet of volume in the room.

Cell B2 contains 10. A formula in C2 is =B2^3. This is 10 to the third power, or 10*10*10 or 1000. — Figure 357. The caret raises a number to a power.

This article is an excerpt from Power Excel With MrExcel

Title photo by Jeremy Bezanger on Unsplash