Using the formula bar as a calculator
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.
Permission is granted for article quotations from OfficeToolTips, provided the direct link to the source articlehttp://www.officetooltips.com/excel 2016/tips/using the formula bar as a calculator.html