Most valuable professional
  • Excel Book Excerpt

Excel Quick Calculator

This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.

Quick Calculator

Problem: I need to find a quick answer to a mathematical problem, and I don’t have a calculator. Can Excel help?

Strategy: You can use Excel as a simple calculator. Follow these steps:

1. Go to a blank cell.

2. Type an equals sign.

3. Enter a calculation.

LE10000277.jpg 

Figure 297 Type = and a calculation in a blank cell.

4. Press the F9 key. Excel will display the result.

LE10000278.jpg 

Figure 298 The result..

5. Press the Esc key to clear the cell.

You can start a formula with equals, plus, or minus signs. You could also have typed +14215469*5.

<-Previous Topic                    Next Topic->

For more resources for Microsoft Excel: