Excel Syntax Support

Interface Overview

1. Dropdown menu to toggle between the syntax expected to be entered by the user in the Editor
   • Google Sheets
   • Microsoft Excel

Interface Overview Continued

1. Example of Excel dialect (formula, ISERROR) in the editor with Microsoft Excel syntax support active
2. Example of Formula Foundry automatically translating the Excel dialect into Google Sheets dialect
   • ISERROR → IFERROR
3. Save code in Editor as a Snippet
4. Pull the contents of the currently selected cell in the Sheet into the Editor
5. Currently selected cell in Sheet
   • Displays the name of the cell currently synced with the Editor
   • Sync (refresh icon) button updates which cell is currently selected in the sheet
6. Insert Editor code (of the currently viewed tab) into the currently synced cell in the sheet

Formulas Currently Supported

1. Smart Fixes
   • Converts IF(ISERROR(…)) to IFERROR(…)
   • Translates AGGREGATE(…) to SUBTOTAL(…)
   • Removes unnecessary ‘–‘ from SUMPRODUCT
2. Function Names
   • Converts statistical functions (e.g., STDEV.S to STDEV)
   • Translates text functions (e.g., LEFTB to LEFT)
   • Remaps common names (e.g., CONCATENATE to CONCAT)
3. Syntax
   • Strips the implicit intersection ‘@’ operator
   • Corrects TEXT(…) function date/time formats
   • Wraps implicit array operations in ARRAYFORMULA()

Please Contact Us us with Requests for additional Syntax Support!

Fill out the form on https://www.formulafoundry.io/support/

Or email us at [email protected]