Change formula recalculation, iteration, or precision in Excel
Use the Open in Excel button to open your workbook to specify calculation options and change formula recalculation, iteration, or precision. Need more help? You can always ask an expert in the Excel Tech Community or get support in Communities .
Remove or allow a circular reference in Excel - Microsoft Support
In the Calculation options section, select the Enable iterative calculation check box. On the Mac, select Use iterative calculation. To set the maximum number of times that Excel will recalculate, type the number of iterations in the Maximum Iterations box.
Change the summary function or custom calculation for a field …
Display or hide subtotals and grand totals in a PivotTable report and calculate them with or without filtered items in Excel.
Show different calculations in PivotTable value fields
Tip: You can use this feature to try different calculations in a value field. However, because you can add the same value fields to a PivotTable more than once, you can also use this feature to show the actual value and other calculations, such as a running total calculation, side by side.
Stale Value Formatting - Microsoft Support
If you click on the icon, you get a menu with options such as triggering calculation or switching to automatic calculation mode. You can also trigger calculations by pressing F9 or clicking the "Calculate Now" button on the Ribbon.
Using calculation operators in Excel formulas - Microsoft Support
Using parentheses allows you to change that calculation order. There are four different types of calculation operators: arithmetic, comparison, text concatenation, and reference.
Overview of formulas in Excel - Microsoft Support
Get started on how to create formulas and use built-in functions to perform calculations and solve problems.
Calculate values in a PivotTable - Microsoft Support
In PivotTables, you can use summary functions in value fields to combine values from the underlying source data. If summary functions and custom calculations do not provide the results that you want, you can create your own formulas in calculated fields and calculated items.
Replace a formula with its result - Microsoft Support
Click the arrow next to Paste Options, and then click Values Only. The following example shows a formula in cell D2 that multiplies cells A2, B2, and a discount derived from C2 to calculate an invoice amount for a sale.
The order in which Excel performs operations in formulas
In some cases, the order in which a calculation is performed can affect the return value of the formula, so it's important to understand how the order is determined and how you can change the order to obtain the results you want.
Calculation operators and precedence in Excel - Microsoft Support
Operators specify the type of calculation that you want to perform on elements in a formula—such as addition, subtraction, multiplication, or division. In this article, you'll learn the default order in which operators act upon the elements in a calculation.