Microsoft Excel: Quick Calculator

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

Problem: You need to find a quick answer to a mathematical problem and you don’t have a calculator.

See all Microsoft Excel tips

Strategy: Follow these steps:

1) Go to a blank cell.

2) Type an Equal sign.

3) Enter a calculation, as shown in Fig. 409.

4) Hit F9 key. Note the result, as shown in Fig. 410.

5) Hit the Esc key to clear the cell.

Summary: Excel can provide a quick calculator in a blank cell by typing the Equal sign, typing in the problem, and then hitting F9.

Commands Discussed: F9 key


See all Microsoft Excel tips
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        

Images

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