Using the formula bar as a calculator

If you simply need to perform a calculation, you can use the Formula bar as a calculator.
For example, enter the following formula, but don't press Enter:

=(145*1.05)/12

If you press Enter, Excel enters the formula into the cell. But because this formula always returns the same result, you may prefer to store the formula's result rather than the formula. To do so, press F9. The result now appears in the Formula bar.

Press Enter to store the result in the active cell. This also works if the formula uses cell references.

Ask a Question

We use your email only for the communication between you and our team.

Your email Please enter your email Your email

If you have any questions or suggestions, please feel free to ask OfficeToolTips team.

Thank you for visiting OfficeToolTips

We are glad to help you in your work. However, you are using ad blocker and our efforts will not be rewarded.

Please consider disabling ad blocker before continuing the reading.