Users can enter a formula in a cell by starting with an equals sign (=). Type the equal sign and then the formula such as = sum(A1+B1). Use Ctrl + Shift + Enter to create an array formula after entering the formula.

You can use the CanUserEditFormula property to prevent this.

Using Code

The following example allows the user to enter formulas.