MrExcel.com - Your One Stop for Excel Tips & Solutions

Quick Calculator

January 20, 2022 - by

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.

Use Excel as a calculator. Type =14215469*5 but don't press Enter.
Figure 285. Type = and a calculation in a blank cell.

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

Press F9 and Excel shows the result 71077345
Figure 286. 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.

This article is an excerpt from Power Excel With MrExcel

Title photo by Amol Tyagi on Unsplash