Formula Editor

Matrix Lead

(4 AppSource 评分)

A modern code editor for Excel functions and formulas.

Do you want to master Excel functions and formulas? Do you want to quickly understand and edit long and complex formulas? Do you want to write correct, succinct, efficient and powerful formulas? Do you want to build error-free and fast spreadsheets?

Functions and formulas are elementary components of spreadsheets and spreadsheet language; they are at the core of Excel editing and programming. However, the current formula editing is constrained by the narrow formula bar or single cell boxes. Formula Editor provides features that existing tools don't have, and helps you to better understand, optimize, and write functions and formulas. Currently, Formula Editor has two major functionalities, more features are coming soon.

Formula Optimization:

  • Formula Editor automatically identifies in your formula the part that can be improved in terms of correctness, readability or efficiency.
  • It suggests better ways to rewrite your formula, and explains to you why they are better, by texts and by videos!
  • You could accept its suggestion of optimization by "Quick Fix".

Formula Formatting:

  • Formula Editor automatically formats a long and complex formula in several lines with appropriate with whitespace indentation and proper nesting.
  • Therefore, you could understand better the logic of the formula.

You could use the add-in inside Excel for Windows, Excel for Mac, and Excel Online with most of modern browsers such as Chrome and Safari; but some functionalities may be disabled inside Excel Online with Internet Explorer.

More details can be found in Give Formula Editor a try, let it help you build safe, neat and powerful spreadsheets!

  • 可读取文档并对其作出更改
  • 可通过 Internet 发送数据
  • 概览