Working With Data

Use math functions and formulas without needing to open Microsoft Excel.

Using Formulas

Editing Formulas

IronXL supports the editing of existing formulas within your spreadsheet without the need for Microsoft Office. This means you can adjust formulas within your spreadsheet to best work with the data available. IronXL currently supports over 165 different formulas

Retrieve Formula Results

Using IronXL, you can easily access the result of any formula within the worksheet, making it easy to work with up to date information that is accurate and best reflects the current data available on the spreadsheet.

Editing Formulas related to Working With Data

Working With Math Functions

Averages

With the Average Function, you can easily calculate the average of any given range, row, or column. All without needing to manually work out the average or use Microsoft Office.

Sum

Use IronXL’s Sum function to calculate the total sum of the numbers within the given range. Automating this will save you time on manual calculations and therefore raise the efficiency of your spreadsheets.

Min

Implementing the Min function to your spreadsheet simplifies the process of identifying the minimum number within a selected range.

Max

The Max function can be implemented to efficiently find the maximum number within a selected range, saving you time and making it easier for analysing the data presented.