Formula Bar Monkey
Article Overview When writing formulas in Excel, users often create a lot of indented formulas. One of the things that kind of drives us nuts
More and more, we’ve been taking advantage of the LET() function when writing our Excel formulas. We find that it makes the formulas easier to read, faster to calculate, and much easier to debug because you can control the final step and control an intermediate calculation very easily.
However, it can be tricky and time-consuming to figure out how to incorporate LET into an existing formula. That is why we built the Letify Monkey!
To quickly convert your formula(s), select the desired workbook cell(s) and go up to the Formula Monkeys area of the Monkey Tools tab. Click on fxMonkeys > Letify Monkey and the dialog will open.
The top of the dialog displays the original formula, and the bottom of the dialog displays the LET version created by the monkey.
The Define Variable Name area of the Leftify Monkey dialog displays a listing of the auto-generated variables used in the LET-ified version of the formula. You can set it so that a pre-defined preface is added to the beginning of all variable names by checking the Auto Name With Preface box and entering the desired preface.
Once the variable preface is entered, the auto-generated variable names on the listing above will be automatically updated to include it. Note that the preface settings are saved between instances of Excel, so when you open a different workbook the same preface will be used.
You can manually rename a variable by clicking on the existing name in the listing and typing in the desired name and pressing Tab. The variable name will be updated in the LET-ified formula at the bottom of the dialog.
The Letify Monkey dialog includes some other helpful features for configuring the variables:
If you have additional formulas you would like to LET-ify, you don’t have to close the dialog. You can simply highlight the desired cell(s) on the underlying worksheet and the dialog will reset so you can name and configured the variables.
Once you are happy with the variable names and configuration, click the Apply button at the bottom of the dialog, and you will see the new formula appears in the worksheet’s formula bar. Click the Close button to close the dialog and return to the worksheet.
Article Overview When writing formulas in Excel, users often create a lot of indented formulas. One of the things that kind of drives us nuts
Article Overview When building Excel solutions, one of the things we really like to do is indent our formulas. It makes them more readable and
Article Overview Monkey Tools offers several Excel feature improvements to build a better user experience. While the vast majority of these features are custom-built to
Article Overview The Connection Monkey is your one stop shop in order to connect to the various Excel workbooks or Power BI models that Monkey
Article Overview What is an application with Options? Monkey Tools is no difference, and we have a specific Options Monkey to help you control them