Improving the readability of formulas through the formula’s variables

1

If Subx team enter such an object as formula’s variables in the QM, then the formulas will become much easier to write and read. For example, it could be implemented like this.
The formula editor will allow an optional section with the definition of formula’s variables according to this scheme:
*
[‘ – the opening tag of the formula’s variables definition section;
Set Variables: $a = definition of the variable ‘a‘ through the QM functions;
…………………..$b = definition of the variable ‘b‘ using the QM function;
……………………………………………………………………………………….;
…………………..$n = definition of the variable ‘n‘ through the QM functions;
]‘ – the closing tag of the formula’s variables definition section.
*
Now, let’s look at the imaginary application of theĀ formula’s variables in the formula from this forum.

*

Pay attention to how much easier it became to read If() logic. Imagine that you need to slightly to change the parameters of Select() – you will only do this once.
*
It would be interesting to hear your feedback on this proposal, so please speak out.

Answered question
0

FYI, Microsoft introduced similar functionality for Excel 2019 by means of the Let() function…
But Subx development team within 1.5 years did not even respond to this offer. Excellent

Answered question
You are viewing 1 out of 9 answers, click here to view all answers.