AI-aided Formula Editor

de Matrix Lead

(17 evaluări)

GPT-4-powered AI features like formula generation and explanation built-in a modern Formula Editor.

AI is revolutionizing the way you work with spreadsheets. This add-in integrates AI features powered by GPT-4 in modern Formula Editors and brings the power of AI to your fingertips to help you better create, understand and edit Excel formulas.

AI formula generation:

  • When you don't know how to write a formula, you can describe it in natural languages, then ask the AI to generate the Excel formula.
  • Formula Editor will help you validate the correctness of the formula. You can preview the result of the formula before adopting it.

AI formula explanation:

  • Whenever you cannot understand a formula or a part of it, you can select it and ask AI to explain it.
  • Formula Editor will provide its evaluation value. AI explanation can be easily triggered by the button, hovering, or shortcuts (Ctrl+K Ctrl+I), and seamlessly assist you in working with formulas.

Other features of Formula Editor:

  • Formula formatting: automatically pretty-print a long and complex formula in several lines with appropriate with whitespace indentation and proper nesting.
  • Error messages: point out on the fly the errors in a formula if they exist, explains the reason and proposes correction.
  • Formula optimization: automatically identify in your formula the part that can be improved in terms of correctness, readability, or efficiency.


  • Default Basic Plan: Users need to sign in to utilize the Default Basic Plan. This plan provides access to all non-AI features, and limited access to AI features.
  • Pro Plan: In the add-in, users have the option to upgrade to the paid Pro Plan. This plan offers unlimited use of all AI features, along with other benefits.

Excel version requirement:

The add-in is built with Excel JavaScript API 1.2 and web libraries that have certain requirements on the version of Excel and operating system; some functionalities can be disabled or a blank page can be displayed if the embedded browser of your Excel is Internet Explorer; in this case, you can always use the add-in in Excel Online in a non-IE browser.

More details can be found in Give the add-in a try, and enjoy the power of AI x Formula Editor!

Capacitățile aplicației

Atunci când această aplicație este utilizată,
  • Poate să citească și să aducă modificări documentului
  • Poate să transmită date prin internet

Dintr-o privire