excel_write_calculation
Insert financial formulas into Excel cells to perform calculations like sum, average, or custom operations, ensuring transparent financial modeling and reporting.
Instructions
Write a calculation to a cell using a formula (not hardcoded value) for transparency
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| worksheetName | Yes | ||
| cell | Yes | Cell address (e.g., 'A3') | |
| operation | Yes | Type of calculation to perform | |
| references | No | Cell references or ranges to include in calculation (e.g., ['A1', 'A2'] or ['A1:A10']) | |
| customFormula | No | Custom formula if operation is 'custom' (e.g., '=A1*B1+C1') | |
| description | No | Optional description of what this calculation represents |