Change the Calculation Mode and input formulas to see the calculation behavior.
Check the different calculate scopes with different calculation types in different calculation modes.