Excel: Quick Calculator

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


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.

  1. Type = and a calculation in a blank cell.
    1. Press the F9 key. Excel will display the result.

  2. The result..
    1. 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.


For more resources for Microsoft Excel