(I'm Vietnamese - I used Google Translate)
Today I share with you the Add-in Parse Formulas into Trees for Easy Formula Editing .
Many of your Excel applications may have very long formulas, when we make formula editing, our eyes see and shape the formula, it is very difficult, so we need a tree part to simplify the work. editing, so I wrote this Add-in to help you simply edit Excel formulas.
Usage is very simple:
For example, we have the formula in cell C6 as:
=IF(SUM(IF("FOO"="BAR",10,0),10)=20,"FOO","BAR")
When double-clicking on cell C6
The formula will be parsed as shown below, returned right at that formula cell.
After pressing Enter or Ctrl+Shift+Enter to execute the formula, if there is a warning as shown below, then type a Space at the beginning of the formula before the "=" sign, to " =" and press Enter or Ctrl +Shift+Enter .
Shortcut: Ctrl+Alt+C to Allow Formula Analysis to work or pause
(Default shortcut is Ctrl+Alt+C, you can change it to your desired shortcut, ^ is Ctrl , + is Shift and % is Alt)
Download the Add-in below and install the Add-in or copy it to the startup XLStart folder of the Excel application.
The add-in is the first version, so there may be errors, so please consider using it, or you can comment below.
Bookmarks