Excel Formula Not Calculating: Just Showing Formula | Formulas Not Calculating Automatically

In this video, I demonstrate four ways of getting your formula to correctly and automatically calculate.  The four reasons that they might not be calculating are:

1) Formulas are entered or formatted as text values
2) Calculation mode is set to manual rather than automatic
3) The 'Show formulas' setting has been turned on
4) You have a circular reference
------------------------

• #howto_style
• #excel_formulas_not_calculating_automatically
• #why_is_my_excel_spreadsheet_showing_my_formula_instead_of_the_answer
• #excel_formula_not_calculating_showing_as_text
• #excel_formula_not_calculating_just_showing_formula
• #why_is_my_excel_formula_not_updating_automatically
• #excel_formula_not_calculating_correctly
• #why_is_my_excel_formula_not_calculating
• #excel_showing_formula_not_calculating
• #excel_cell_formula_not_calculating
• #microsoft_excel