# Using Formulas

Set the following properties to configure formula evaluation when executing SELECT, INSERT, and UPDATE statements.

## Selecting Formulas

The provider can return either the result of the formula or the formula itself; configure this behavior with the __ValueRenderOption__ connection property.

## Inserting and Updating Formulas

Set __AllowFormula__ to true to insert formulas (the default). Otherwise, all values used in inserts and updates are inserted as string literals.

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 __AllowFormula__ is set to true, every column containing a formula will be exposed as *String* type regardless of the set __TypeDetectionScheme__.