Spread Windows Forms 7.0 Product Documentation
Nesting Functions in a Formula
See Also Support Options
Spread Windows Forms 7.0 Product Documentation > Developer's Guide > Customizing Interaction in Cells > Managing Formulas in Cells > Nesting Functions in a Formula

Glossary Item Box

You can nest a function within another function in a formula.

For information on using the Formula Editor to enter a formula at design time, refer to Entering a Formula in Spread Designer. For details on the functions and operators that can be used to create a formula, refer to the Formula Reference.

Using Code

  1. Specify the reference type, if cells are referenced in the formula.
  2. Use a function within another function in a formula

Example

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
fpSpread1.Sheets[0].Cells[3, 1].Formula = "PRODUCT(A1, SUM(A2,A3))";
VB Copy Code
FpSpread1.Sheets(0).Cells(3, 1).Formula = "PRODUCT(A1, SUM(A2,A3))"

See Also

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.