8 ms·
You can do multiline formulas in the advanced formula environment, but still follows the same syntax as the formula language (with comments). i.e.: =LET(
by Closi 2y ago
You can do multiline formulas in the advanced formula environment, but still follows the same syntax as the formula language (with comments). i.e.:
=LET(
x,1, // assign 1 to y
y,2, // assign 2 to y
x+y // add x and y
)
Same with LAMBDAs
- layer8 2y agoYou can use Alt+Enter to create multiline formulas in normal formula entry. In addition, the formula bar can be dragged down (or press Ctrl+Shift+U) to be multiline [0]. One drawback is that you can’t use the Tab key for indentation and have to use spaces. [0] https://www.ablebits.com/office-addins-blog/formula-bar-excel/ https://www.ablebits.com/office-addins-blog/formula-bar-exce...