# SetFormula

Use the SetFormula method to set the formula in a cell at the specified row and column. Learn its syntax and parameters in documentation.

## Content

Sets the formula in a cell at the specified row and column.

## Syntax

[JavaScript]

```javascript
FpSpread1.SetFormula(row,column,value);
```

## Parameters

***row***
Integer, row index of cell
***column***
Integer, column index of cell
***value***
String, the formula to put in the cell

## Return Type

None

## Remarks

Both row and column indexes must be integer values and must be valid. The formula is parsed and evaluated when the data is posted back to the server. This method does not cause a postback to occur. For a list of the operators and functions that appear in formulas, refer to the [Formula Reference](https://developer.mescius.com/spreadnet/docs/latest/online-formula/overview.html). Be sure to start the formula with an equals sign (=).

## Example

This is a sample that contains the method. On the client side, the script that contains the method would look like this:

```javascript
<script type="text/javascript">
   function setEquation() {
        FpSpread1.SetFormula(5,3,"= A1 + B1 / C1");
   }
</script>
```

## See Also

[GetFormula](/spreadnet/docs/latest/online-asp/overview/spweb-clientscriptref/clientscript-members/clientscript-allmeths/CSSR-GetFormula)
[Scripting Members](/spreadnet/docs/latest/online-asp/overview/spweb-clientscriptref/clientscript-members)