Microsoft Excel: Use ^ Sign For Exponent

Article by Mr Excel (11,387 pts ) , published Jul 1, 2008

Problem: You have a room that is 10 feet x 10 feet x 10 feet. What is the volume of the cube?

See all Microsoft Excel tips

Strategy: The formula for volume is width x length x height. In this case, it is 10 x 10 x 10, or ten to the third power. In Excel, the carat symbol (also known as “the little hat”, or “the symbol when you press Shift 6”) is used to calculate exponents. In cell B2, enter 10; in cell B3, enter the formula =B2^3. The result will be 1000 cubic feet of volume in the room, as shown in Fig. 435.

Summary: Use a carat to calculate exponents.


See all Microsoft Excel tips

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  

Images

Fig. 435
 
Subscribe to Home Office
RSS
Get free weekly updates, directly to your inbox.