You can use built-in functions and operators to develop formulas and perform calculations. Add calculations quickly to your applications by using any of over 300 pre-defined functions or add your own custom functions. Choose from any of these types of functions:
- Database
- Date and Time
- Engineering
- Financial
- Information
- Logic
- Lookup and Reference
- Math and Trigonometry
- Statistics
- Text
- Volatile
Spread also offers a floating formula bar that you can provide to your end users to allow them to pick functions.
You can also create custom formulas or custom names to use in formulas. Refer to Creating and Using a Custom Function and Creating and Using a Custom Name for more information.
For more information on entering formulas using the Spread Designer, refer to the Spread Designer Guide.
For more information on formulas in general, refer to Managing Formulas in Cells and to the Formula Reference.