# AllowFormula

Whether or not to treat values starting with an equals (=) sign as formulas during inserts and updates.

### Syntax

propertyAllowFormula: Boolean;

### Data Type

Boolean

### Default Value

true

### Remarks

Set this value to true to treat values beginning with an equals (=) sign as formulas on inserts and updates. Set the value to false to treat all values used in inserts and updates as strings.

For example, with __AllowFormula__ set to true, the following will insert a formula into the B column that will sum cells B1:B5:

INSERT INTO Excel_Sheet (A, B) VALUES ('Bill', '=SUM(B1:B5)')

**Note:** If True, every column containing a formula will be exposed as *String* type regardless of the set TypeDetectionScheme.