# Formulas in Cells

Learn how to set up and perform calculations using formulas in cells, including placing a formula, specifying references, using circular references, nesting functions, and more.

## Content

You can set up and perform calculations using formulas in cells. This may involve these tasks:

* [Placing a Formula in Cells](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-cell-formula/spwin-formulaplace)
* [Displaying Formula in Cells](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-cell-formula/spwin-displayingformulaIncells)
* [Specifying a Cell Reference in a Formula](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-cell-formula/spwin-formulacellref)
* [Specifying a Sheet Reference in a Formula](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-cell-formula/spwin-formulasheetref)
* [Specifying an External Reference in a Formula](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-cell-formula/spwin-externalref)
* [Using a Circular Reference in a Formula](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-cell-formula/spwin-formulacircref)
* [Nesting Functions in a Formula](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-cell-formula/spwin-formulanested)
* [Recalculating and Updating Formulas Automatically](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-cell-formula/spwin-formularecalc)
* [Finding a Value Using GoalSeek](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-cell-formula/spwin-formula-goalseek)
* [Allowing the User to Enter Formulas](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-cell-formula/spwin-formulaallowuser)
* [Creating and Using a Custom Name](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-cell-formula/spwin-formulacustomname)
* [Creating and Using a Custom Function](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-cell-formula/spwin-formulacustomfunc)
* [Creating and Using a Visual Function](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-cell-formula/creating-using-visual-function)
* [Creating and Using External Variable](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-cell-formula/spwin-external-variable)
* [Using the Array Formula](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-cell-formula/spwin-arrayformula)
* [Working With Dynamic Array Formulas](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-cell-formula/WorkingWithDynamicArrayFormulas)
* [Working with the Formula Text Box](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-cell-formula/spwin-formulabar)
* [Setting up the Name Box](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-cell-formula/spwin-namebox)
* [Using Language Package](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-cell-formula/UsingLanguagePackage)
* [Accessing Data from Header or Footer](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-cell-formula/spwin-headerfooterformula)
* [Auto Format Formulas](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-cell-formula/auto-format-formulas)
* [Managing External Reference](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-cell-formula/spwin-extrenalreference)
* [Precedents and Dependents](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-cell-formula/precedents-dependents)

For more information on entering formulas using the Spread Designer, refer to [Entering a Formula in Spread Designer](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-design/spwin-spd-setformula).
For information on the floating formula bar, where users can type in formulas and select cells dynamically, refer to [Setting up the Formula Text Box](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-cell-formula/spwin-formulabar).
For an overview of formulas and details on the functions and operators that can be used to create a formula, refer to the [Formula Reference](https://developer.mescius.com/spreadnet/docs/latest/online-formula/overview).
For information on the **CalcEngine** assembly, which is responsible for the formula calculations, refer to the [FarPoint.CalcEngine](/spreadnet/api/latest/online-win/FarPoint.CalcEngine/FarPoint.CalcEngine.html).

## See Also

[Developer's Guide](/spreadnet/docs/latest/online-win/overview/spwin-devguide)
[Assembly Reference](/spreadnet/docs/latest/online-win/overview/assembly-reference)
[Spread Designer Guide](/spreadnet/docs/latest/online-win/overview/spwin-designerguide)