Fix broken formulas in Excel


Excel 2013

  • Always start with an equal sign (=)

  • Each opening parenthesis needs a closing parenthesis

  • Use unformatted numbers in formulas (like 1000 instead of $1,000)

  • Use quotation marks around text

Excel 2016

  • Always start with an equal sign (=)

  • Each opening parenthesis needs a closing parenthesis

  • Use unformatted numbers in formulas (like 1000 instead of $1,000)

  • Use quotation marks around text