Spread for ASP.NET 8.0 Product Documentation > Developer's Guide > Managing Formulas > Nesting Functions in a Formula |
You can nest a function within another function in a formula.
For more information about formulas, refer to the Formula Reference.
In this example the sum of the value in two cells (found by using the SUM function) is embedded in a PRODUCT formula. First the cell types are set and the values of the cells are set.
C# |
Copy Code
|
---|---|
FarPoint.Web.Spread.DoubleCellType ncell = new FarPoint.Web.Spread.DoubleCellType(); FpSpread1.Sheets[0].Cells[0, 0, 2, 0].CellType = ncell; FpSpread1.Sheets[0].Cells[0, 0, 2, 0].Value = 2; FpSpread1.Sheets[0].Cells[3, 1].Formula = "PRODUCT(A1, SUM(A2,A3))"; |
VB |
Copy Code
|
---|---|
Dim ncell As New FarPoint.Web.Spread.DoubleCellType FpSpread1.Sheets(0).Cells(0, 0, 2, 0).CellType = ncell FpSpread1.Sheets(0).Cells(0, 0, 2, 0).Value = 2 FpSpread1.Sheets(0).Cells(3, 1).Formula = "PRODUCT(A1, SUM(A2,A3))" |