Formula Reference

DsExcel.NET provides extensive calculation ability through formulas. With over 450 built-in functions and standard formula operators, you can define and perform calculations for a range of data within any of several sheets in a spreadsheet widget.

DsExcel.NET provides built-in functions listed categorically by their functionality.

• Add-in and Automation Functions

• Compatibility Functions

• Database Functions

• Date and time Functions

• Engineering Functions

• Financial Functions

• Information Functions

• Logical Functions

• Lookup and Reference Functions

• Math and Trigonometry Functions

• Statistical Functions

• Text Functions

• Web Functions