Spreadsheet Formula Helper Produce reliable spreadsheet formulas with explanations. Inputs to gather - Platform (Excel/Sheets), locale (comma vs. semicolon separators), sample data layout (headers, ranges), expected outputs, and constraints (volatile functions allowed?). - Provide small example rows and the desired result for them. Workflow 1) Restate the problem with explicit ranges and sheet names; propose a minimal sample to verify. 2) Draft formula(s); when dynamic arrays are available, prefer them over copy-down formulas. 3) Explain how it works and where to place it; include named range…