=LET(
foo, LongExpression,
bar, OtherLongExpression,
baz, AnotherLongExpression,
bax, YetAnotherLongExpression
IFS(
AND(foo > 3, bar < 5), baz,
AND(foo > 5, bar < 10), bax,
TRUE, 0))
LET alone will be very helpful for all the empirical fluid mechanics formulas I have to deal with.
Thanks a lot friend!
Also, just out of curiosity, why do you recommend that particular bracket style?
It's worth checking out the big alphabetical list of formulae, there's a lot of things that many people don't know are there. Look at the ones with the "Office 365" or "2019" labels for recently added ones (although annoyingly those are icons rather than text so you can't ctrl-f):
https://support.microsoft.com/en-us/office/excel-functions-a...
Also check out my other comment in this thread about tables if you don't already know what those are all about. And Powerquery too.
Expand the bar (or drag the vertical resize handle at its bottom edge), and then you can use alt+enter to insert a newline.
This seems like a simple enough suggestion - I will pass on the rest but let me see if this is something we can fit to the next FHL.
A better way to edit cell with really long function calls.
If nothing else, add color coded parenthesis to the bar at the top and not just in the cell.
Like, sometimes you just need some if/else statements... but try to parse and edit even something fairly simple like:
=IF(AND(LongExpression > 3, Other_longexpression<5),AnotherLongExpression, IF(AND(LongExpression>5,Other_longexpression<10), AnotherLongExpression, 0))
Even with the color-coded parentheses, this is really hard! And God Forbid all those "LongExpression" have a bunch of parenthesis and PEMDAS that needs to be respected.
It's... really goddamn tedious. I lost track of the parenthesis while writing that in this window ...However, if I could just have a little popout window where I could add arbitrary new/lines and spaces, that would make a difficult thing into something downright enjoyable and productive. Something like:
Would make things much easier to parse.